Hi Lou, Try setting wal_keep_segments parameter to a higher value. I think it will suffice to solve the problem.
Regards, Pavan Teja, 9841380956 On Sun, 7 Apr, 2019, 6:53 PM Lou Tseng, <lts...@advancedpricing.com> 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? > > 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 > > lts...@advancedpricing.com > <http://www.advancedpricing.com/> > Advanced Medical Pricing Solutions <http://advancedpricing.com/> > 35 Technology Parkway South, Suite. 100 > Peachtree Corners, GA 30092 > >
