| From: | Lou Tseng <ltseng(at)advancedpricing(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Logical replication failed recovery |
| Date: | 2019-04-07 13:22:50 |
| Message-ID: | DM6PR11MB2939FF65103200D9F8BA88BCC4530@DM6PR11MB2939.namprd11.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
ltseng(at)advancedpricing(dot)com<mailto:ltseng(at)advancedpricing(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Teja | 2019-04-07 13:27:43 | Re: Logical replication failed recovery |
| Previous Message | Joe Conway | 2019-04-07 13:08:23 | Re: Query much slower on 9.6.5 than on 9.3.5 |
