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(at)advancedpricing(dot)com <mailto:ltseng(at)advancedpricing(dot)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(dot)klaver(at)aklaver(dot)com