From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ray Stell <stellr@vt.edu>
cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: change pid/gid
In-reply-to: <d994516f-c9d5-ec89-9802-8f4bd5e8ee2b@vt.edu>
References: <d994516f-c9d5-ec89-9802-8f4bd5e8ee2b@vt.edu>
Comments: In-reply-to Ray Stell <stellr@vt.edu>
	message dated "Fri, 09 Dec 2016 10:21:43 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <16943.1481297638.1@sss.pgh.pa.us>
Date: Fri, 09 Dec 2016 10:33:58 -0500
Message-ID: <16944.1481297638@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Ray Stell <stellr@vt.edu> writes:
> Due to some external, sysadmin issues, I'm forced to change the pid/gid 
> of the postresql user on CentOS6.  I'm wondering if this plan of action 
> has any flaws.

Changing file ownership should be sufficient as far as PG itself is
concerned, but if you have SELinux enabled (which you should) I'm
not certain how this will affect its rules.  I think that the answer
is "it doesn't", or at worst that you'd need to reboot after changing
the /etc/passwd mapping, but it's something to keep a side eye on.

			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