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

Поиск
Список
Период
Сортировка
От Kumar, Devesh
Тема DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1
Дата
Msg-id CACMEH=4R1_oYrmE4qh2v38ZqWthLt3Q3UKOQN4=B2+RaBsCGTA@mail.gmail.com
обсуждение исходный текст
Ответы Re: DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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.
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #18445: date_part / extract range for hours do not match documentation
Следующее
От: Marek Läll
Дата:
Сообщение: Re: BUG #18445: date_part / extract range for hours do not match documentation