Re: [ADMIN] change pid/gid - Mailing list pgsql-admin

From hubert depesz lubaczewski
Subject Re: [ADMIN] change pid/gid
Date
Msg-id 20161209162256.3kcftdxa366jua5r@depesz.com
Whole thread Raw
In response to [ADMIN] change pid/gid  (Ray Stell <stellr@vt.edu>)
List pgsql-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/


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN] change pid/gid
Next
From: Mike Broers
Date:
Subject: [ADMIN] switching replication from standard asynch to slots