Re: In what situations do you use -U of initdb? - Mailing list pgsql-general

From Tsunakawa, Takayuki
Subject Re: In what situations do you use -U of initdb?
Date
Msg-id 0A3221C70F24FB45833433255569204D08C1E4DA@G01JPEXMBYT03
Whole thread Raw
In response to Re: In what situations do you use -U of initdb?  (Abel Abraham Camarillo Ojeda <acamari@the00z.org>)
Responses Re: In what situations do you use -U of initdb?
List pgsql-general
Thanks.  I didn't even imagine such a situation.

I'd like to hear other cases like:

- Packaged applications (not OS) that embeds or uses PostgreSQL
- The corporate environment where some security policy is enforced that the OS user and the database administrator user
mustbe different
 

Regards
Takayuki Tsunakawa

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Abel Abraham
> Camarillo Ojeda
> Sent: Monday, May 13, 2013 2:01 PM
> To: Tsunakawa, Takayuki/綱川 貴之
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] In what situations do you use -U of initdb?
> 
> Package systems which create an automatic user account for your
> postgresql instance, for example in OpenBSD:
> 
> system user: _postgresql (in accordance to OpenBSD ports rules)
> db user: postgres
> 
> I always use:
> 
> initdb -U postgres
> 
> Because that's what everyone expects it to be...
>

pgsql-general by date:

Previous
From: Amit Langote
Date:
Subject: Re: PAM implementation in PG 9.2.3
Next
From: Arvind Singh
Date:
Subject: Re: PG Stats Collector