<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Also,</p>
<p>I gave rds_superuser,rds_replication to the connecting user(i.e
table owner). This time, I get a different error</p>
<p><br>
<font size="2" face="Courier New, Courier, monospace">(21282) [Fri
Oct 22 15:22:52 2021] MCP Starting check_sync_health<br>
(21327) [Fri Oct 22 15:23:03 2021] KID (AURORASYNC) New kid,
sync "AURORASYNC" alive=1 Parent=21286 PID=21327 kicked=1<br>
(21327) [Fri Oct 22 15:23:03 2021] KID (AURORASYNC) Disabling
indexes for DEST.public.bucardo_test<br>
(21327) [Fri Oct 22 15:23:03 2021] KID (AURORASYNC) Kid has
died, error is: DBD::Pg::db do failed: ERROR: permission denied
for table pg_class at /usr/local/share/perl/5.30.0/Bucardo.pm
line 5525. Line: 5037 Main DB state: ? Error: none DB DEST
state: 42501 Error: 7 DB SRC state: ? Error: none<br>
(21327) [Fri Oct 22 15:23:03 2021] KID (AURORASYNC) Kid 21327
exiting at cleanup_kid. Sync "AURORASYNC" public.bucardo_test
Reason: DBD::Pg::db do failed: ERROR: permission denied for
table pg_class at /usr/local/share/perl/5.30.0/Bucardo.pm line
5525. Line: 5037 Main DB state: ? Error: none DB DEST state:
42501 Error: 7 DB SRC state: ? Error: none<br>
(21282) [Fri Oct 22 15:23:03 2021] MCP Starting
check_sync_health</font><br>
<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 23/10/2021 1:05 am, Akheel Ahmed
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:9edefbee-423b-f2aa-438b-96e512dbcb78@gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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>
</blockquote>
</body>
</html>