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