From: | Marcin Giedz <marcin(dot)giedz(at)arise(dot)pl> |
---|---|
To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | some questions regarding replication issues and timeline/history files |
Date: | 2020-12-20 18:52:01 |
Message-ID: | 654901459.1968500.1608490321788.JavaMail.zimbra@arise.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I've created synchronous replication between Primary and Secondary server and put pacemaker + PAF over. Client is doing some stress tests (switching nodes, disabling particular node, etc) and it's second time when this kind of problem occoures :
2020-12-18 14:03:46.658 CET [unknown] [28787]ERROR: requested starting point F/A2000000 on timeline 39 is not in this server's history
2020-12-18 14:03:46.658 CET [unknown] [28787]DETAIL: This server's history forked from timeline 39 at F/A1023338.
questions:
1. what does this mean ? How this can happen ? Does this mean that for some "point in time" both servers were primary ?
2. in xxx.history files I find the following rows:
43 F/A60000A0 no recovery target specified
44 F/A70000A0 no recovery target specified
45 F/A80000A0 no recovery target specified
again: what does this mean ?
3. general question: can anyone suggest deep explanation of timelines and history files to understand how this postgresql nature works ?
Many thx
Marcin
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Pereira | 2020-12-20 19:11:25 | Prevent pg_rewind destroying the data |
Previous Message | Adrian Klaver | 2020-12-20 17:58:09 | Re: Missing rows after migrating from postgres 11 to 12 with logical replication |