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

On Sun, May 12, 2013 at 11:20 PM, Tsunakawa, Takayuki
<tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> wrote:
> Hello,
>
> Currently, we are developing some tool for PostgreSQL. To determine the functional specification, I would like to ask PostgreSQL users about the necessity of support for the -U option of initdb.
>
> In what situations do you use -U option of initdb? Is it essential for what reason?
>
> I'm not sure whether there are any situations where the DBAs need to use different username/password pairs for the OS user who starts/stops the database server, and the database superuser.
>
>
> Regards
> Takayuki Tsunakawa
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general