From: | Muhammad Waqas <waqas(dot)m(at)bitnine(dot)net> |
---|---|
To: | Domen Šetar <domen(dot)setar(at)izum(dot)si> |
Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: wal seams to be corrupted |
Date: | 2024-07-30 12:40:49 |
Message-ID: | CAHYHq4Vk=-6RG8LHVbx49zG39V9u3YhyBNO9RRfTS65JEo99pg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
This is not the corruption I guess
Please check availability of WAL file at OS level
2024년 7월 19일 (금) 오전 10:57, Domen Šetar <domen(dot)setar(at)izum(dot)si>님이 작성:
> 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
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2024-07-30 13:35:06 | Re: Migration from CentOS7 to RHEL red hat Linux |
Previous Message | Muhammad Waqas | 2024-07-30 12:37:46 | Re: Detect who ran DROP schema |