From: Wolfgang Wilhelm <wolfgang20121964@yahoo.de>
To: David G. Johnston <david.g.johnston@gmail.com>
To: Maki Smith (US - IFS) <maki.smith@pwc.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: running postgresql with a different id other than postgres user
Date: Wed, 20 Jul 2016 08:12:53 +0000 (UTC)
Message-ID: <1964189799.3313708.1469002373028.JavaMail.yahoo@mail.yahoo.com> (raw)
In-Reply-To: <CAKFQuwYys+fSietKAa2h1GZcuRX7Co22DXBT+-9FNARB2tFk7g@mail.gmail.com>
References: <CAKiXyGS2t20-rPCZb52JiWau2Kp8eGKcGt6+H8anWBbijE41CQ@mail.gmail.com>
<CAKFQuwYys+fSietKAa2h1GZcuRX7Co22DXBT+-9FNARB2tFk7g@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.g.johnston@gmail.com> schrieb am 21:34 Dienstag, 19.Juli 2016:
On Tue, Jul 19, 2016 at 3:16 PM, Maki Smith (US - IFS) <maki.smith@pwc.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: wolfgang20121964@yahoo.de, david.g.johnston@gmail.com, maki.smith@pwc.com
Subject: Re: running postgresql with a different id other than postgres user
In-Reply-To: <1964189799.3313708.1469002373028.JavaMail.yahoo@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox