From: | "Kumar, Devesh" <devesh(dot)kumar(at)cmegroup(dot)com> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1 |
Date: | 2024-04-26 19:06:56 |
Message-ID: | CACMEH=4R1_oYrmE4qh2v38ZqWthLt3Q3UKOQN4=B2+RaBsCGTA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)kumar(at)cmegroup(dot)com <firstname(dot)lastname(at)cmegroup(dot)com>
[image: 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
<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.
From | Date | Subject | |
---|---|---|---|
Next Message | Marek Läll | 2024-04-26 19:27:49 | Re: BUG #18445: date_part / extract range for hours do not match documentation |
Previous Message | David G. Johnston | 2024-04-26 13:06:30 | Re: BUG #18445: date_part / extract range for hours do not match documentation |