Logical replication failed recovery - Mailing list pgsql-general

From Lou Tseng
Subject Logical replication failed recovery
Date
Msg-id DM6PR11MB2939FF65103200D9F8BA88BCC4530@DM6PR11MB2939.namprd11.prod.outlook.com
Whole thread Raw
Responses Re: Logical replication failed recovery  (Pavan Teja <pavan.postgresdba@gmail.com>)
Re: Logical replication failed recovery  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi folks,

Is there a good tutorial to recover from logical replication out of sync?  We ran into this error stating WAL has been removed and now replica is out of sync.  Also, is there a way to increase the number of WAL kept on the master?

Thanks!

2019-04-07 12:28:37.180 UTC [22292] ERROR:  could not receive data from WAL stream: ERROR:  requested WAL segment 0000000100005208000000EB has already been removed

2019-04-07 12:28:37.182 UTC [114186] LOG:  worker process: logical replication worker for subscription 8907992 (PID 22292) exited with exit code 1


Lou Tseng

ltseng@advancedpricing.com
Advanced Medical Pricing Solutions
35 Technology Parkway South, Suite. 100
Peachtree Corners, GA 30092

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Query much slower on 9.6.5 than on 9.3.5
Next
From: Pavan Teja
Date:
Subject: Re: Logical replication failed recovery