| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "prakhar jauhari *EXTERN*" <prak840(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Does postgres user on linux need login permission? |
| Date: | 2013-08-27 08:25:22 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17C08DA5@ntex2010a.host.magwien.gv.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gabriele Bartolini | 2013-08-27 08:33:01 | Re: Does postgres user on linux need login permission? |
| Previous Message | prakhar jauhari | 2013-08-27 07:58:47 | Does postgres user on linux need login permission? |