From: hubert depesz lubaczewski <depesz@depesz.com>
To: Ray Stell <stellr@vt.edu>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: change pid/gid
Date: Fri, 9 Dec 2016 17:22:56 +0100
Message-ID: <20161209162256.3kcftdxa366jua5r@depesz.com> (raw)
In-Reply-To: <d994516f-c9d5-ec89-9802-8f4bd5e8ee2b@vt.edu>
References: <d994516f-c9d5-ec89-9802-8f4bd5e8ee2b@vt.edu>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Fri, Dec 09, 2016 at 10:21:43AM -0500, Ray Stell wrote:
> 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. It seemed to work in a test environment to shutdown and change the
> pid/gid via:
>
>
> find / -uid 1500 -exec chown -h 2500:2500 {} \; (as root, of course)
> Startup went ok, but I've not done this in production and find myself a
> little nervous. I'll test in a hotstandby config here in a moment. Any
> gotchas hiding in there?
no real gotchas, but change \; to + so that it will be MUCH faster.
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
--
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: depesz@depesz.com, stellr@vt.edu
Subject: Re: change pid/gid
In-Reply-To: <20161209162256.3kcftdxa366jua5r@depesz.com>
* 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