<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi</p>
<p>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. <br>
</p>
<p>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.<br>
</p>
<p><font size="1" face="Courier New, Courier, monospace">(20943)
[Fri Oct 22 14:43:26 2021] KID (AURORASYNC) New kid, sync
"AURORASYNC" alive=1 Parent=20865 PID=20943 kicked=1<br>
(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<br>
(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<br>
(20861) [Fri Oct 22 14:43:26 2021] MCP Starting
check_sync_health<br>
</font></p>
<p>Help appreciated.</p>
<p>Thanks<br>
</p>
</body>
</html>