From: | Domen Šetar <domen(dot)setar(at)izum(dot)si> |
---|---|
To: | Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com> |
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-19 06:28:43 |
Message-ID: | 9c2e2f9c884444109866578df8dca3fe@izum.si |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks for the answer.
What about to stop postgresql server which is primary in replication and promote another server?
Best regards!
[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<http://www.izum.si/> | domen(dot)setar(at)izum(dot)si<mailto:domen(dot)setar(at)izum(dot)si>
From: Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
Sent: Friday, July 19, 2024 8:10 AM
To: Domen Šetar <domen(dot)setar(at)izum(dot)si>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: wal seams to be corrupted
Hi Domen
On Fri, Jul 19, 2024 at 10:57 AM Domen Šetar <domen(dot)setar(at)izum(dot)si<mailto: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?
Yes you should use the pg_resetwal what it does is clears the write-ahead log (WAL) and optionally resets some other control information stored in the pg_control file. This function is sometimes needed if these files have become corrupted. It should be used only as a last resort, when the server will not start due to such corruption.
You can find the help from the following link
https://www.postgresql.org/docs/current/app-pgresetwal.html
Regards
Kashif Zeeshan
Best regards!
[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<http://www.izum.si/> | domen(dot)setar(at)izum(dot)si<mailto:domen(dot)setar(at)izum(dot)si>
From | Date | Subject | |
---|---|---|---|
Next Message | Domen Šetar | 2024-07-19 06:37:19 | RE: wal seams to be corrupted |
Previous Message | David G. Johnston | 2024-07-19 06:27:36 | Re: wal seams to be corrupted |