Re: [GENERAL] In what situations do you use -U of initdb?

2013-05-14 Thread Kevin Grittner
"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

Re: [GENERAL] In what situations do you use -U of initdb?

2013-05-13 Thread Ray Stell
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

Re: [GENERAL] In what situations do you use -U of initdb?

2013-05-13 Thread Tsunakawa, Takayuki
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) >

Re: [GENERAL] In what situations do you use -U of initdb?

2013-05-12 Thread Abel Abraham Camarillo Ojeda
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

[GENERAL] In what situations do you use -U of initdb?

2013-05-12 Thread Tsunakawa, Takayuki
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