Re: In what situations do you use -U of initdb?

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...
>