RE: wal seams to be corrupted - Mailing list pgsql-admin

Yes. Sometimes we don't see obvious.

I noticed now that I don't have disk checks fort his host on Icinga and I'm adding some now. 😉

Hi,

glad you found the problem. Had it in mind but didn’t dare to say it 😉

Maybe you want to install a monitor software like check_mk or Icinga. We use both and uptime_kuma to get noticed if services trend to fail or have failed.

BTW: check_mk and the  PostgreSQL is also a very nice tool.

Best regards,

Anton

Thank you admins for helping me.

The problem was stupid and I'm a little bit ashamed.

Archive disk was full and I didn't notice it.

I made some space on it and everything is ok know.

Hi admins,

The number of wal files on my postgresql server is rising, because it seams that one wal is corrupted. Postgrsql is running normaly.  I see this in postgresql log file:

2024-07-19 07:44:12 CEST [2205]: [32288-1] user=,db=,app=,client= DETAIL:  The failed archive command was: test ! -f /var/lib/pgsql/ArchiveDir/000000010000044E0000009D && cp pg_wal/000000010000044E0000009D /var/lib/pgsql/ArchiveDir/000000010000044E0000009D

Usualy helped if I deleted wal in ArchiveDir directory. But not this time. Wal is copied again from pg_wal to ArchiveDir directory and  error message continues.

What can I do to solve this problem? Is pg_resetwal solution fort his problem? If it is, how to use it?

Best regards!