| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | Ray Stell <stellr(at)vt(dot)edu> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: change pid/gid |
| Date: | 2016-12-09 16:22:56 |
| Message-ID: | 20161209162256.3kcftdxa366jua5r@depesz.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Broers | 2016-12-09 19:48:12 | switching replication from standard asynch to slots |
| Previous Message | Tom Lane | 2016-12-09 15:33:58 | Re: change pid/gid |