<div dir="ltr">Hello,<br><br>I am trying to set up multi-master replication on AWS RDS using this guide: <a href="https://medium.com/preply-engineering/postgres-multimaster-34f2446d5e14" target="_blank">https://medium.com/preply-engineering/postgres-multimaster-34f2446d5e14</a><br><br>So far it works well (with some pg_hba.conf changes), but I'm stuck at the `<font face="monospace">bucardo add sync mydb_sync herd=sample_herd dbs=mydb_servers_group</font>` step.<br><br>I get this error:<br><br><font face="monospace">WARNING:  Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=vf_production;host=<a href="http://vf-production-test-copy.redacted.ap-southeast-1.rds.amazonaws.com/" target="_blank">vf-production-test-copy.redacted.ap-southeast-1.rds.amazonaws.com</a>;port=5432 at line 29.<br>CONTEXT:  PL/Perl function "validate_sync"<br>SQL statement "SELECT validate_sync('mydb_sync')"<br>PL/Perl function "validate_sync"<br>Failed to add sync: DBD::Pg::st execute failed: ERROR:  DBD::Pg::db do failed: ERROR:  permission denied for relation spatial_ref_sys at line 126. at line 30.<br>CONTEXT:  PL/Perl function "validate_sync" at /usr/bin/bucardo line 4612.</font><br><br>From Googling around it seems that all users in the bucardo.db table needs to be superusers. I'm unsure how to check it, are these the correct users to check?:<br><br><font face="monospace">bucardo=# \du<br>                                     List of roles<br>   Role name   |                         Attributes                         | Member of<br>---------------+------------------------------------------------------------+-----------<br> bucardo       | Superuser                                                  | {}<br> postgres      | Superuser, Create role, Create DB, Replication, Bypass RLS | {}<br><br>bucardo=# SELECT * FROM db;<br>-[ RECORD 1 ]--------+------------------------------------------------------------------------<br>name                 | source_db<br>dbtype               | postgres<br>dbhost               | <a href="http://vf-production-test-copy.redacted.ap-southeast-1.rds.amazonaws.com/" target="_blank">vf-production-test-copy.redacted.ap-southeast-1.rds.amazonaws.com</a><br>dbport               | 5432<br>dbname               | vf_production<br>dbuser               | vf_db<br>dbpass               | redacted<br>dbconn               |<br>dbservice            |<br>pgpass               |<br>status               | active<br>server_side_prepares | t<br>makedelta            | f<br>cdate                | 2020-01-30 05:41:21.796437+00</font><br><font face="monospace">-[ RECORD 2 ]--------+------------------------------------------------------------------------<br>name                 | dest_db<br>dbtype               | postgres<br>dbhost               | <a href="http://vf-production-test-copy-2.redacted.ap-southeast-1.rds.amazonaws.com/" target="_blank">vf-production-test-copy-2.redacted.ap-southeast-1.rds.amazonaws.com</a><br>dbport               | 5432<br>dbname               | vf_production<br>dbuser               | vf_db<br>dbpass               | redacted<br>dbconn               |<br>dbservice            |<br>pgpass               |<br>status               | active<br>server_side_prepares | t<br>makedelta            | f<br>cdate                | 2020-01-30 06:11:16.029221+00</font><br><br>vf_db is an rds_superuser in the RDS.<br><br>I'm not sure what else I can check or do, why can't I sync?<br><br>Thank you.<div class="gmail-yj6qo"></div><div class="gmail-adL"><br></div></div>