Also,
I gave rds_superuser,rds_replication to the connecting user(i.e table
owner). This time, I get a different error
(21282) [Fri Oct 22 15:22:52 2021] MCP Starting check_sync_health
(21327) [Fri Oct 22 15:23:03 2021] KID (AURORASYNC) New kid, sync
"AURORASYNC" alive=1 Parent=21286 PID=21327 kicked=1
(21327) [Fri Oct 22 15:23:03 2021] KID (AURORASYNC) Disabling indexes
for DEST.public.bucardo_test
(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
(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
(21282) [Fri Oct 22 15:23:03 2021] MCP Starting check_sync_health
On 23/10/2021 1:05 am, Akheel Ahmed wrote:
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
_______________________________________________
Bucardo-general mailing list
[email protected]
https://bucardo.org/mailman/listinfo/bucardo-general
