Re: wal seams to be corrupted

Hi Domen Setar,

If your database is running normal then backup your database before going
for any solution.

Regards,
Ikram

On Fri, Jul 19, 2024 at 10:57 AM Domen Šetar <domen(dot)setar(at)izum(dot)si> wrote:

> 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!
>
> [image: izum]
>
> Domen Šetar
> *Computer Systems Support*
> IZUM – Institute of Information Science | Prešernova ulica 17 | 2000
> Maribor | Slovenia
> T: +386 2 25 20 339 | M: +386 41 676 342 | www.izum.si |
> domen(dot)setar(at)izum(dot)si
>
>
>
>
>

--
Muhammad Ikram