From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Kumar, Devesh <devesh.kumar@cmegroup.com>
To: pgsql-bugs@lists.postgresql.org
Subject: Re: DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1
Date: Mon, 29 Apr 2024 12:07:29 +0200
Message-ID: <967d0513557c9d12cbe3a35b6318e32712edcf2d.camel@cybertec.at> (raw)
In-Reply-To: <CACMEH=4R1_oYrmE4qh2v38ZqWthLt3Q3UKOQN4=B2+RaBsCGTA@mail.gmail.com>
References: <CACMEH=4R1_oYrmE4qh2v38ZqWthLt3Q3UKOQN4=B2+RaBsCGTA@mail.gmail.com>
On Sat, 2024-04-27 at 00:36 +0530, Kumar, Devesh wrote:
> Currently we are working on setting up replication and testing failover scenarios
> and failback. During our testing, failover is getting successful. During Failback,
> when we are reverting the original primary instance as the new standby, we are
> getting pg_rewind errors. Kindly can someone check and let us know.
>
> pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1
> pg_rewind: error: could not open file "/pgresdata101/data/pg_wal/000000010000000000000008": No such file or directory
> pg_rewind: error: could not find previous WAL record at 0/802B668
You should show the exact commands used for failover and failback.
Yours,
Laurenz Albe
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-bugs@postgresql.org
Cc: laurenz.albe@cybertec.at, devesh.kumar@cmegroup.com, pgsql-bugs@lists.postgresql.org
Subject: Re: DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1
In-Reply-To: <967d0513557c9d12cbe3a35b6318e32712edcf2d.camel@cybertec.at>
* 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