pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDoes postgres user on linux need login permission?
3+ messages / 3 participants
[nested] [flat]
* Does postgres user on linux need login permission?
@ 2013-08-27 07:58 prakhar jauhari <prak840@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: prakhar jauhari @ 2013-08-27 07:58 UTC (permalink / raw)
To: pgsql-admin
Hey,
I am using postgres9.2, on a linux 6.3 box.
For start i created a user postgres on linux with login permission and no
password.
Is it necessary for the postgres user to have login permissions?
Can i change it to "no login" with out breaking basebackup and Streaming
Replication from other machines.?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Does postgres user on linux need login permission?
@ 2013-08-27 08:25 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: prakhar jauhari <prak840@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Albe Laurenz @ 2013-08-27 08:25 UTC (permalink / raw)
To: prakhar jauhari *EXTERN* <prak840@gmail.com>; pgsql-admin
prakhar jauhari wrote:
> I am using postgres9.2, on a linux 6.3 box.
>
> For start i created a user postgres on linux with login permission and no password.
>
>
> Is it necessary for the postgres user to have login permissions?
>
> Can i change it to "no login" with out breaking basebackup and Streaming Replication from other
> machines.?
You need to be the PostgreSQL user when you create the database cluster
or start and stop the database server.
As long as you can become the user with "su", that should be ok.
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Does postgres user on linux need login permission?
@ 2013-08-27 08:33 Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
parent: prakhar jauhari <prak840@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Gabriele Bartolini @ 2013-08-27 08:33 UTC (permalink / raw)
To: prakhar jauhari <prak840@gmail.com>; +Cc: pgsql-admin
On Tue, 27 Aug 2013 13:28:47 +0530, prakhar jauhari <prak840@gmail.com>
wrote:
> Hey,
>
> I am using postgres9.2, on a linux 6.3 box.
> For start i created a user postgres on linux with login permission
> and no password.
I usually advice to set it up as a system user (see the -r option for
useradd) and access to it through the "root" user using sudo/su or
public SSH key authentication. Just leave it as is, with no password.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
Gabriele.Bartolini@2ndQuadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-08-27 08:33 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-08-27 07:58 Does postgres user on linux need login permission? prakhar jauhari <prak840@gmail.com>
2013-08-27 08:25 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2013-08-27 08:33 ` Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox