To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
From: Ray Stell <stellr@vt.edu>
Subject: change pid/gid
Message-ID: <d994516f-c9d5-ec89-9802-8f4bd5e8ee2b@vt.edu>
Date: Fri, 9 Dec 2016 10:21:43 -0500
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:45.0)
 Gecko/20100101 Thunderbird/45.5.1
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------2B69901BFFBE858F8677B097"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------2B69901BFFBE858F8677B097
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

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)

--------------2B69901BFFBE858F8677B097
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=utf-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <p>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:</p>
    <p><br>
      <span class="gmail-s1">    find / -uid 1500 -exec chown -h
        2500:2500 {} \;        </span><span class="gmail-s1">(as root,
        of course)</span></p>
    <p><span class="gmail-s1"><br>
      </span></p>
    <p>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?  <br>
    </p>
    <p>BTW, -h will change symlinks, which I found handy. <br>
    </p>
        -h, --no-dereference<br>
                  affect each symbolic link instead of any referenced
    file (useful only on systems that can change the ownership of a
    symlink)<br>
  </body>
</html>

--------------2B69901BFFBE858F8677B097--