Re: Does postgres user on linux need login permission?

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: Raw Message | Whole Thread | 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

In response to

Browse pgsql-admin by date

  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?