Re: running postgresql with a different id other than postgres user

From: Wolfgang Wilhelm <wolfgang20121964(at)yahoo(dot)de>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "Maki Smith (US - IFS)" <maki(dot)smith(at)pwc(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: running postgresql with a different id other than postgres user
Date: 2016-07-20 08:12:53
Message-ID: 1964189799.3313708.1469002373028.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

a little more information would be helpful.But to make things short: The user who starts the initdb command is the database admin user. When you install PostgreSQL via the tool of your distribution like apt (Debian), yum or whatever then the package manager generates the user postgres and executes initdb as user postgres.
Kind regards,Wolfgang

David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> schrieb am 21:34 Dienstag, 19.Juli 2016:

On Tue, Jul 19, 2016 at 3:16 PM, Maki Smith (US - IFS) <maki(dot)smith(at)pwc(dot)com> wrote:

To meet our security requirement, we would like to use another account other than postgres to install and run postgreSQL.  Is this possible to do?

​You need to tell us by what method you intend to install PostgreSQL, and on what platform, before this can be usefully answered.​
The documentation covers how to go about installing from source.  It should cover how to choose a label different than "postgres" if you so desire.
David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gupta, Amar Nath 2016-07-20 10:45:02 High-end PG database configuration help
Previous Message Gilberto Castillo 2016-07-19 20:22:13 Re: [MASSMAIL] running postgresql with a different id other than postgres user