1) What sort of replication? - Streaming replication 2) Where are the two servers located relative to each other? - The servers are located in different data centers. 3) Has there been any software upgrades/network changes recently? - I don't know any information about the software upgrades/network суббота, 25 января 2025г., 19:31 +03:00 от Adrian Klaver adrian.kla...@aklaver.com :
>On 1/25/25 06:58, Дмитрий wrote: > Hello everyone! > > Please help me with the error: FATAL: could not send data to WAL stream: > lost synchronization with server: got message type "0", length 892351284 . > Replication worked for more than a month and now there is such a > problem. Restarting PostgreSQL helps. > How can I fix this error? >This is going to need more information: > >1) What sort of replication? > >2) Where are the two servers located relative to each other? > >3) Has there been any software upgrades/network changes recently? > > > Source: > PostgreSQL 15.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 > 20150623 (Red Hat 4.8.5-44), 64-bit > CentOS Linux release 7.8.2003 (Core) > Filesystem type ext4 > > Receiver: > PostgreSQL 15.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 > 20240719 (Red Hat 11.5.0-2), 64-bit > Red Hat Enterprise Linux release 9.5 (Plow) > Filesystem type xfs > > > Thank you. > > >-- >Adrian Klaver >adrian.kla...@aklaver.com
