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 Von: Domen
Šetar <domen.setar@xxxxxxx> 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.
Best regards!
From:
Domen Šetar 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!
|