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