From: Kris Deugau <kdeugau@vianet.ca>
To: 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 16:16:55 -0400
Message-ID: <578FDC37.8080507@vianet.ca> (raw)
In-Reply-To: <CAKiXyGTtxHRa5qhnWP8R+aUXW_QpMdqMZtwMJHjYRtk9Ni8OnA@mail.gmail.com>
References: <CAKiXyGS2t20-rPCZb52JiWau2Kp8eGKcGt6+H8anWBbijE41CQ@mail.gmail.com>
<CAKFQuwYys+fSietKAa2h1GZcuRX7Co22DXBT+-9FNARB2tFk7g@mail.gmail.com>
<1964189799.3313708.1469002373028.JavaMail.yahoo@mail.yahoo.com>
<CAKiXyGTtxHRa5qhnWP8R+aUXW_QpMdqMZtwMJHjYRtk9Ni8OnA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Maki Smith (US - IFS) wrote:
> 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...
Can you explain your security requirement in more detail? It sounds to
me like you're going to a lot of effort for something that isn't going
to do what you want to do, or what you think it'll do.
It may also cause issues on package upgrades, because the packages will
continue to operate on the assumption that the username created by the
package is the one that Postgres is running under. You'd likely end up
running Postgres in a by-hand enough manner that you may as well just
install from source anyway.
-kgd
--
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: kdeugau@vianet.ca
Subject: Re: running postgresql with a different id other than postgres user
In-Reply-To: <578FDC37.8080507@vianet.ca>
* 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