Fedora Account System
Red Hat Associate
Red Hat Customer
Description of problem: re-added replication subscription fails after running backup restore. Version-Release number of selected component (if applicable):5.6.4 How reproducible:100% Steps to Reproduce: 1.Provision 2 appliances rr99 rr1 2.Setup rr1 to remote region 3.Add subscription to global rr99 4.Add provider to confirm replication is working 5.Backup db's 6.Remove replication setting from both rr99-rr1 7.stop evmserverd both appliances 8.dropdb/createdb both appliances 9.run appliance_console restore on both appliances 10.Reconfigure pglogical replication step 2/3^^ 11.Add or remove provider Actual results:Nothing is replicated from rr1 to rr99 Expected results:Replication completes successfully Additional info: I used pg_dump to create my backups
Luke, Could you test if executing backup/restore in a way described in https://bugzilla.redhat.com/show_bug.cgi?id=1459652 will keep pglogical replication work
Backup and restore method does keep the pglogical replication configuration but it no longer functions correctly. We see backlog increase in size after restore and nothing being replicated.
It is however possible to drop and re-add the subscription on the global region, But that kinda defeats the point I think.
I think steps to make sure that subscription works after restoring binary back-up should be documented together with steps for DB back-up/restore described in https://bugzilla.redhat.com/show_bug.cgi?id=1459652
BZ1459652, which documents how to perform a binary backup and restore, has now been closed out with input from Yuri. Closing this bug as a duplicate for now. *** This bug has been marked as a duplicate of bug 1459652 ***