Re: Logical replication failed recovery

On 4/7/19 6:22 AM, Lou Tseng wrote:
> 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?

I have to believe there is more to the story. When a subscription is 
enabled it sets up a replication 
slot(www.postgresql.org/docs/11/warm-standby.html#STREAMING-REPLICATION-SLOTS) 
that should ensure that the WAL is not recycled until it is used. Did 
you stop a Subscription then
restart it? Or one of the other scenarios shown here?:

https://www.postgresql.org/docs/11/logical-replication-subscription.html#LOGICAL-REPLICATION-SUBSCRIPTION-SLOT

> 
> 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 <mailto:ltseng@advancedpricing.com>
> <http://www.advancedpricing.com/>
> Advanced Medical Pricing Solutions <http://advancedpricing.com/>
> 35 Technology Parkway South, Suite. 100
> Peachtree Corners, GA 30092
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com