Re: Installing Postgres without the postgres user and group on Linux? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Installing Postgres without the postgres user and group on Linux?
Date
Msg-id 20631.1358958516@sss.pgh.pa.us
Whole thread Raw
In response to Installing Postgres without the postgres user and group on Linux?  ("Plugge, Joe R." <JRPlugge@west.com>)
Responses Re: Installing Postgres without the postgres user and group on Linux?  ("Plugge, Joe R." <JRPlugge@west.com>)
List pgsql-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
andgroup?  We have some folks implementing LDAP that are resistant to creating a postgres account and group and would
rathercreate 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
installationprocess 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


pgsql-admin by date:

Previous
From: Prashanth Ranjalkar
Date:
Subject: Re: vacuum / analyze parent tables on partitioned tables.
Next
From: "Plugge, Joe R."
Date:
Subject: Re: Installing Postgres without the postgres user and group on Linux?