DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1 - Mailing list pgsql-bugs

From Kumar, Devesh
Subject DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1
Date
Msg-id CACMEH=4R1_oYrmE4qh2v38ZqWthLt3Q3UKOQN4=B2+RaBsCGTA@mail.gmail.com
Whole thread Raw
Responses Re: DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1
List pgsql-bugs
Hello,

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.


DETAIL: pg_rewind command is "/opt/postgresql/pg/bin/pg_rewind -D '/pgresdata101/data' --source-server='host=10.29.97.241 port=5432 user=repmgr dbname=repmgr connect_timeout=2'"
DEBUG: executing:
  /opt/postgresql/pg/bin/pg_rewind -D '/pgresdata101/data' --source-server='host=10.29.97.241 port=5432 user=repmgr dbname=repmgr connect_timeout=2' 2>/tmp/repmgr_command.wgVGPS
DEBUG: result of command was 1 (256)
DEBUG: local_command(): output returned was:
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

___________________________

DEVESH KUMAR

Database Admin I – India

M: +91 6366843695

devesh.kumar@cmegroup.com



CC24_EC010-Great-Place-to-Work-India-email-sign-260x100px_v2 (1) (1).jpg

Address: Tridib Building Block B 5th Floor

Bagmane Tech Park CV Raman Nagar,

Bengaluru,  560093,  IN
www.cmegroup.com

 



NOTICE: This message, and any attachments, are for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at https://www.cmegroup.com/tools-information/communications/e-communication-disclaimer.html If you are not the intended recipient, please delete this message. CME Group and its subsidiaries reserve the right to monitor all email communications that occur on CME Group information systems.
Attachment

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #18445: date_part / extract range for hours do not match documentation
Next
From: Marek Läll
Date:
Subject: Re: BUG #18445: date_part / extract range for hours do not match documentation