Re: pg_basebackup issue

John R Pierce <pierce@xxxxxxxxxxxx> · Sat, 22 Apr 2017 02:38:08 -0700



    On 4/22/2017 2:28 AM, chiru r wrote:

    
      I am using Postgresql 9.5
          and I have created backup_admin user and created dba_admin
          ROLE with SUPERUSER and REPLICATION ,after that GRANT dba_admin  role   to backup_admin
          user and
          executed  pg_basebakup utility with backup_admin user. 
    
    
    role group membership only inherits object rights, like grant
      ..... on table ... to role.   it doesn't inherit role attributes
      like SUPERUSER, or REPLICATION.  you need to ALTER ROLE to add
      these to each role.
    

    -- 
john r pierce, recycling bits in santa cruz