Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL file corruption on standby PostgreSQL - Mailing list pgsql-admin

From Muhammad Ikram
Subject Re: WAL file corruption on standby PostgreSQL
Date
Msg-id CAGeimVoLwB_Qw6z_0ns4FLarZ_hZXUD-WYUwDBktvJOGfVq0Mg@mail.gmail.com
Whole thread Raw
In response to WAL file corruption on standby PostgreSQL  (Wasim Devale <wasimd60@gmail.com>)
Responses Re: WAL file corruption on standby PostgreSQL
List pgsql-admin
Tree view
Hi Wasim,

IMO, you will have to rebuild the standby server by taking base backup from Primary and copying it to standby, restart standby. Also try to see what caused corruption of WAL archives.

Regards
Muhammad Ikram



On Mon, Jul 22, 2024 at 11:26 PM Wasim Devale <wasimd60@gmail.com> wrote:
Hi All

2024-07-22 11:15:10 PDT [1723]: [7028-1] user=,db=,app=,client= LOG:  restored log file "000000010000170900000081" from archive
2024-07-22 11:15:10 PDT [1723]: [7029-1] user=,db=,app=,client= LOG:  invalid resource manager ID 128 at 1709/8183BFA8
2024-07-22 11:15:10 PDT [1723]: [7030-1] user=,db=,app=,client= LOG:  invalid resource manager ID 128 at 1709/8183BFA8


I got this error and the replication has stopped. Please suggest about invalid resource manager ID.

Thanks,
Wasim


--
Muhammad Ikram

pgsql-admin by date:

Previous
From: Wasim Devale
Date:
Subject: WAL file corruption on standby PostgreSQL
Next
From: Muhammad Ikram
Date:
Subject: Re: Oracle to Postgres