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

From: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
To: Abel Abraham Camarillo Ojeda <acamari(at)the00z(dot)org>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: In what situations do you use -U of initdb?
Date: 2013-05-13 08:34:58
Message-ID: 0A3221C70F24FB45833433255569204D08C1E4DA@G01JPEXMBYT03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks. I didn't even imagine such a situation.

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

Regards
Takayuki Tsunakawa

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Abel Abraham
> Camarillo Ojeda
> Sent: Monday, May 13, 2013 2:01 PM
> To: Tsunakawa, Takayuki/綱川 貴之
> Cc: pgsql-general(at)postgresql(dot)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)
> db user: postgres
>
> I always use:
>
> initdb -U postgres
>
> Because that's what everyone expects it to be...
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arvind Singh 2013-05-13 10:08:03 Re: PG Stats Collector
Previous Message Amit Langote 2013-05-13 05:47:56 Re: PAM implementation in PG 9.2.3