Re: FATAL: could not send data to WAL stream: lost synchronization with server: got message type "0", length 892351284

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(dot)klaver(at)aklaver(dot)com