Thanks you. The FATAL message is not clear. Yes, It is helpful if someone with more knowledge of the connection code.
[postgres@pgserver ~]$ /opt/PostgreSQL/9.5/bin/pg_basebackup --format=t --pgdata=online_backups1 -p 5432 -U *backup_admin* -x -z --verbose *pg_basebackup: could not connect to server: FATAL: must be superuser or replication role to start walsender* On Sat, Apr 22, 2017 at 2:00 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 04/22/2017 10:04 AM, chiru r wrote: > >> Thanks for the reply, >> >> Actually I am not setting Role for database specific,I did set Role to >> user. >> Since users and roles are global for all databases in PostgreSQL,I >> believe it should work for replication pesudo database. >> > > Except for the part where the 'replication' database does not actually > exist, so I am not seeing how a connection could be established to it. Now > whether a replication connection is supposed to honor SET ROLE is something > someone with more knowledge of the connection code will have to answer. The > evidence says it does not. > > >> Thanks, >> Chiru >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
