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