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
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.klaver@xxxxxxxxxxx
