Re: DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "Kumar, Devesh" <devesh(dot)kumar(at)cmegroup(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1
Date: 2024-04-29 10:07:29
Message-ID: 967d0513557c9d12cbe3a35b6318e32712edcf2d.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Shlok Kyal 2024-04-29 10:14:29 Re: BUG #18433: Logical replication timeout
Previous Message Melody 2024-04-29 06:42:20 回复：Re: BUG #18450: The memory usage of the postgresql12.6 walsender process is abnormally high.