Re: Does postgres user on linux need login permission? - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: Does postgres user on linux need login permission?
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17C08DA5@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Does postgres user on linux need login permission?  (prakhar jauhari <prak840@gmail.com>)
List 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

pgsql-admin by date:

Previous
From: prakhar jauhari
Date:
Subject: Does postgres user on linux need login permission?
Next
From: Gabriele Bartolini
Date:
Subject: Re: Does postgres user on linux need login permission?