Postgres Pro
Downloads
Home   >   mailing lists

Re: running postgresql with a different id other than postgres user - Mailing list pgsql-admin

From Maki Smith (US - IFS)
Subject Re: running postgresql with a different id other than postgres user
Date
Msg-id CAKiXyGTtxHRa5qhnWP8R+aUXW_QpMdqMZtwMJHjYRtk9Ni8OnA@mail.gmail.com
Whole thread Raw
In response to Re: running postgresql with a different id other than postgres user  (Wolfgang Wilhelm <wolfgang20121964@yahoo.de>)
Responses Re: running postgresql with a different id other than postgres user
List pgsql-admin
Tree view
I successfully installed from source with a different user other than postgres on Ubuntu.
However now I am curious we can do any modification like this when I install PostgreSQL via the tool, like apt-get or yum.
As you mentioned, these tools creates postgres user automatically. 

If we use a tool like this, we need to create another superuser as post-installation procedure to switch user, and stop usage of postgres default user..

Just curious.. how people is doing this type of scenario...


-----------------------------------------------------------------------------------------------------------------------------------------
Maki Smith US IT - Technical Design Authority Infrastructure | PricewaterhouseCoopers LLP 
4040 West Boy Scout Boulevard, Tampa, FL 33607 | Phn: 1.813.351.2481 | Fax: 1.813.375.6084 | RightFax: 1.813.375.6087 | Notes: maki.smith@us.pwc.com | gmail: maki.smith@pwc.com

On Wed, Jul 20, 2016 at 4:12 AM, Wolfgang Wilhelm <wolfgang20121964@yahoo.de> wrote:
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.




The information transmitted, including any attachments, is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited, and all liability arising therefrom is disclaimed. If you received this in error, please contact the sender and delete the material from any computer. PricewaterhouseCoopers LLP is a Delaware limited liability partnership. This communication may come from PricewaterhouseCoopers LLP or one of its subsidiaries.

pgsql-admin by date:

Previous
From: "Gupta, Amar Nath"
Date:
Subject: High-end PG database configuration help
Next
From: Kris Deugau
Date:
Subject: Re: running postgresql with a different id other than postgres user