Bug 1419017

Summary:	pglogical replication fails after backup restore
Product:	Red Hat CloudForms Management Engine	Reporter:	luke couzens <lcouzens>
Component:	Documentation	Assignee:	Red Hat CloudForms Documentation <cloudforms-docs>
Status:	CLOSED DUPLICATE	QA Contact:	Red Hat CloudForms Documentation <cloudforms-docs>
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	5.6.0	CC:	abellott, adahms, hhudgeon, jhardy, lcouzens, obarenbo, yrudman
Target Milestone:	GA
Target Release:	cfme-future
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:	black:replication
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2018-02-27 00:47:48 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description luke couzens 2017-02-03 12:36:37 UTC

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

Comment 2 Yuri Rudman 2017-06-13 12:42:57 UTC

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

Comment 3 luke couzens 2017-06-13 15:53:07 UTC

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.

Comment 4 luke couzens 2017-06-13 15:55:59 UTC

It is however possible to drop and re-add the subscription on the global region, But that kinda defeats the point I think.

Comment 5 Yuri Rudman 2017-06-14 13:13:38 UTC

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

Comment 6 Andrew Dahms 2018-02-27 00:47:48 UTC

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 ***