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:
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
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
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: