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<mailto:lts...@advancedpricing.com> [http://advancedpricing.com/wp-content/uploads/logo_AMPS_email.png]<http://www.advancedpricing.com/> Advanced Medical Pricing Solutions<http://advancedpricing.com/> 35 Technology Parkway South, Suite. 100 Peachtree Corners, GA 30092