[Bucardo-general] Source DB error when adding the sync

[Lucas Possamai]

Hi all,

When executing the command below, my source db collapsed. Looked like lots
of locks and waits were happening.

bucardo add sync test_sync relgroup=test_db_group dbs=test_db_group
autokick=0

The steps I'm doing are:

   - PG DUMP the database from source
   - Create roles and apply database permissions to target
   - Import the Database dump to the target DB (RDS)
   - Enable session_replication_role on Target
   - Bucardo add source DB
   - Bucardo add target DB
   - bucardo add tables
      - bucardo add table public.* db=source_db relgroup=test_db_group
      - bucardo add sequences
      - bucardo add sequence public.* db=source_db relgroup=test_db_group
      - bucardo add dbgroup
      - bucardo add dbgroup test_db_group source_db:source target_db:target
      - bucardo add sync
      - bucardo add sync test_sync relgroup=test_db_group dbs=test_db_group
      autokick=0


Are those locks expected when adding the sync on the source db? Any other
recommendations?

Source DB is PostgreSQL 9.2
Target DB is PostgreSQL 12.4
Bucardo version is: 5.6.0

Cheers,
---
Kind regards,

*Lucas Possamai*
lpossamai.me
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210413/46b4d8ce/attachment.htm>