[Bucardo-general] Kid has died, error is: DBD::Pg::db do failed: ERROR: permission denied to set parameter "session_replication_role" at /usr/local/share/perl/5.30.0/Bucardo.pm line 5359

[Akheel Ahmed]

Hi

I have setup source, dest, relgroup and sync. When I start Bucardo, I 
see a constant flurry of these messages. The source and target 
connections are made using the owner of the tables being replicated.

The source and target are Amazon Aurora postgresql environments, source 
being 9.6.16 and target at 12.7. Does the connecting user need to have 
superuser privilege? AWS Aurora wouldn't allow creation/alteration of a 
role to include superuser privileges.

(20943) [Fri Oct 22 14:43:26 2021] KID (AURORASYNC) New kid, sync 
"AURORASYNC" alive=1 Parent=20865 PID=20943 kicked=1
(20943) [Fri Oct 22 14:43:26 2021] KID (AURORASYNC) Kid has died, error 
is: DBD::Pg::db do failed: ERROR:  permission denied to set parameter 
"session_replication_role" at /usr/local/share/perl/5.30.0/Bucardo.pm 
line 5359. Line: 5037 Main DB state: ? Error: none DB DEST state: 42501 
Error: 7 DB SRC state: ? Error: none
(20943) [Fri Oct 22 14:43:26 2021] KID (AURORASYNC) Kid 20943 exiting at 
cleanup_kid. Sync "AURORASYNC" public.bucardo_test Reason: DBD::Pg::db 
do failed: ERROR:  permission denied to set parameter 
"session_replication_role" at /usr/local/share/perl/5.30.0/Bucardo.pm 
line 5359. Line: 5037 Main DB state: ? Error: none DB DEST state: 42501 
Error: 7 DB SRC state: ? Error: none
(20861) [Fri Oct 22 14:43:26 2021] MCP Starting check_sync_health

Help appreciated.

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20211023/4a4b1df8/attachment.htm>