Postgres Pro
Downloads
Home   >   mailing lists

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

From Kashif Zeeshan
Subject Re: wal seams to be corrupted
Date
Msg-id CAAPsdhdmjOW8tApxYo0WT5vwJCS3=CSFdBrROUG3zbbDTuubuw@mail.gmail.com
Whole thread Raw
In response to wal seams to be corrupted  (Domen Šetar <domen.setar@izum.si>)
Responses Re: wal seams to be corrupted
RE: wal seams to be corrupted
List pgsql-admin
Tree view
Hi Domen

On Fri, Jul 19, 2024 at 10:57 AM Domen Šetar <domen.setar@izum.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

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 | domen.setar@izum.si

 

 

Attachment

pgsql-admin by date:

Previous
From: Domen Šetar
Date:
Subject: wal seams to be corrupted
Next
From: Muhammad Ikram
Date:
Subject: Re: wal seams to be corrupted