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.takay@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
