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.ta...@jp.fujitsu.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to