From: Tom Lane <tgl@sss.pgh.pa.us>
To: Plugge, Joe R. <JRPlugge@west.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Installing Postgres without the postgres user and group on Linux?
Date: Wed, 23 Jan 2013 11:28:36 -0500
Message-ID: <20631.1358958516@sss.pgh.pa.us> (raw)
In-Reply-To: <BD69807DAE0CE44CA00A8338D0FDD083034C920A5F@oma00cexmbx03.corp.westworlds.com>
References: <BD69807DAE0CE44CA00A8338D0FDD083034C920A5F@oma00cexmbx03.corp.westworlds.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
"Plugge, Joe R." <JRPlugge@west.com> writes:
> Is it possible to install and then subsequently run the postgres engine on Linux without creating the postgres user and group? We have some folks implementing LDAP that are resistant to creating a postgres account and group and would rather create machine specific accounts (like one does for Windows with SQL Server).
The server source code has no particular allegiance to any OS username.
You can run it under whatever account you want.
> I always thought that if the postgres user and group were not there upon install (which is done as root), that the installation process would create them for you, am I missing something?
Particular packagings of Postgres might act like that --- for instance,
the Fedora/Red Hat RPMs would try to create such a user&group. But you
did not say whose packaging you were thinking of using. In any case
you could run the executables under some other user ID if you then
adjusted file ownerships and startup scripts appropriately.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: tgl@sss.pgh.pa.us, JRPlugge@west.com
Subject: Re: Installing Postgres without the postgres user and group on Linux?
In-Reply-To: <20631.1358958516@sss.pgh.pa.us>
* 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