Re: Data Packaging/Data Unpacking - Mailing list pgsql-general

From oleg yusim
Subject Re: Data Packaging/Data Unpacking
Date
Msg-id CAKd4e_EgT3ZN2CTxSch1g0LutfwKZ60Yo9A1EeGbr44A8yD1aQ@mail.gmail.com
Whole thread Raw
In response to Re: Data Packaging/Data Unpacking  (Kevin Grittner <kgrittn@gmail.com>)
List pgsql-general
Kevin,

It is understood. But doesn't change things from my perspective. It would anyway be user, with sole access, nobody can elevate privileges to and only root can su to. The name, in that case, is irrelevant, but answer postgres gave me idea of the protection level here.

Thanks,

Oleg

On Wed, Jan 13, 2016 at 4:04 PM, Kevin Grittner <kgrittn@gmail.com> wrote:
On Wed, Jan 13, 2016 at 3:54 PM, oleg yusim <olegyusim@gmail.com> wrote:

> Answer "postgres" would suffice.

But the user would not always be "postgres".  To be accurate, it is
the user which owns the files for the "cluster" (database instance)
and which runs the database service.  If a machine contains
multiple clusters it is (IMO) best practice, for both security and
operational reasons, to use a separate OS user for each cluster.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Data Packaging/Data Unpacking
Next
From: "Williamson, Michael"
Date:
Subject: v9.1, DROP TRIGGER IF EXISTS behaving oddly