Postgres Pro
Downloads
Home   >   mailing lists

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

From Muhammad Ikram
Subject Re: wal seams to be corrupted
Date
Msg-id CAGeimVrO+rA-o5aDOBCo334fKLa5Lwi5qvHtzf50p9uEPCGNzg@mail.gmail.com
Whole thread Raw
In response to wal seams to be corrupted  (Domen Šetar <domen.setar@izum.si>)
List pgsql-admin
Tree view
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.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?

 

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

 

 



--
Muhammad Ikram

Attachment

pgsql-admin by date:

Previous
From: Kashif Zeeshan
Date:
Subject: Re: wal seams to be corrupted
Next
From: "David G. Johnston"
Date:
Subject: Re: wal seams to be corrupted