Re: replication primary writting infinite number of WAL files

Am 24.11.23 um 12:39 schrieb Les:
>
> Hello,
>
> Yesterday we were faced with a problem that we do not understand and
> cannot solve ourselves. We have a postgresql cluster using repmgr,
> which has three members. The version of all instances (currently) is
> "PostgreSQL 14.5 (Debian 14.5-2.pgdg110+2) on x86_64-pc-linux-gnu,
> compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit.". Under
> normal circumstances, the number of write operations is relatively
> low, with an average of 4-5 MB/sec total write speed on the disk
> associated with the data directory. Yesterday, the primary server
> suddenly started writing to the pg_wal directory at a crazy pace,
> 1.5GB/sec, but sometimes it went up to over 3GB/sec. The pg_wal
> started fattening up and didn't stop until it ran out of disk space.
>

please check the database log, a VACUUM can also lead to massive wal
generation. Can you find other related messages? by the way, the picture
is hard to read, please post text instead of pictures.

Regards, Andreas

--
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com