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.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
