[ADMIN] change pid/gid

Поиск
Список
Период
Сортировка
От Ray Stell
Тема [ADMIN] change pid/gid
Дата
Msg-id d994516f-c9d5-ec89-9802-8f4bd5e8ee2b@vt.edu
обсуждение исходный текст
Ответы Re: [ADMIN] change pid/gid  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [ADMIN] change pid/gid  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-admin

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? 

BTW, -h will change symlinks, which I found handy.
    -h, --no-dereference
              affect each symbolic link instead of any referenced file (useful only on systems that can change the ownership of a symlink)

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ray Stell
Дата:
Сообщение: [ADMIN] change PID/GID
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] change pid/gid