pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFrom: vrms <vrms@netcologne.de>
To: pgsql-admin@lists.postgresql.org
Subject: Re: WAL file corruption on standby PostgreSQL
Date: Mon, 22 Jul 2024 21:24:50 +0200
Message-ID: <0322e728-fe36-45a4-9667-299246028db8@netcologne.de> (raw)
In-Reply-To: <CAGeimVoLwB_Qw6z_0ns4FLarZ_hZXUD-WYUwDBktvJOGfVq0Mg@mail.gmail.com>
References: <CAB5fag5B=mX1O57uy7SjpWQowgCJuoiXQnYpe-ziUDY2Oy27iA@mail.gmail.com>
<CAGeimVoLwB_Qw6z_0ns4FLarZ_hZXUD-WYUwDBktvJOGfVq0Mg@mail.gmail.com>
On 7/22/24 8:42 PM, Muhammad Ikram wrote:
>> Also try to see what caused corruption of WAL archives.
out of curiosity ... any hint in how to approach this?
On 7/22/24 8:42 PM, Muhammad Ikram wrote:
> 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
>
view thread (6+ messages) latest in thread
Message-ID: <0322e728-fe36-45a4-9667-299246028db8@netcologne.de>
Permalink: ../0322e728-fe36-45a4-9667-299246028db8@netcologne.de/
Also on: postgresql.org/message-id/0322e728-fe36-45a4-9667-299246028db8@netcologne.de
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vrms@netcologne.de, pgsql-admin@lists.postgresql.org
Subject: Re: WAL file corruption on standby PostgreSQL
In-Reply-To: <0322e728-fe36-45a4-9667-299246028db8@netcologne.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox