"Tsunakawa, Takayuki" wrote:
> 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
> must be different
Well, where I
On May 13, 2013, at 12:20 AM, Tsunakawa, Takayuki wrote:
> 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.
I was thinking obscurity might be a good f
al@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)
>
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
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 n