Re: Logical replication failed recovery

2019-04-09 Thread Adrian Klaver
Peachtree Corners, GA 30092 *From:* Adrian Klaver *Sent:* Sunday, April 7, 2019 10:05 AM *To:* Lou Tseng; pgsql-general@lists.postgresql.org *Subject:* Re: Logical replication failed recovery On 4/7/19 6:22 AM, Lou Tseng wrote:

Re: Logical replication failed recovery

2019-04-07 Thread Adrian Klaver
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 beli

Re: Logical replication failed recovery

2019-04-07 Thread Pavan Teja
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, wrote: > Hi folks, > > Is there a good tutorial to recover from logical replication out of sync? > We ran int

Logical replication failed recovery

2019-04-07 Thread Lou Tseng
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: