Search Postgresql Archives

Logical replication failed recovery

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxxxx
Advanced Medical Pricing Solutions
35 Technology Parkway South, Suite. 100
Peachtree Corners, GA 30092


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux