| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org,Michael Paquier <michael(at)paquier(dot)xyz>,Alexander Kukushkin <cyberdemn(at)gmail(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>,Dmitry Dolgov <9erthalion6(at)gmail(dot)com> |
| Subject: | Re: BUG #15346: Replica fails to start after the crash |
| Date: | 2018-08-28 05:08:33 |
| Message-ID: | 3B69F535-FD81-461B-97E9-657D4C99EDB4@anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On August 28, 2018 11:44:09 AM GMT+09:00, Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>On Sat, Aug 25, 2018 at 09:54:39AM +0200, Alexander Kukushkin wrote:
>> Why the number of tuples in the xlog is greater than the number of
>> tuples on the index page?
>> Because this page was already overwritten and its LSN is HIGHER than
>> the current LSN!
>
>That's annoying. Because that means that the control file of your
>server maps to a consistent point which is older than some of the
>relation pages. How was the base backup of this node created? Please
>remember that when taking a base backup from a standby, you should
>backup the control file last, as there is no control of end backup with
>records available. So it seems to me that the origin of your problem
>comes from an incorrect base backup expectation?
Uh, where is that "control file last" bit coming from?
Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Kukushkin | 2018-08-28 06:21:57 | Re: BUG #15346: Replica fails to start after the crash |
| Previous Message | Michael Paquier | 2018-08-28 03:20:40 | Re: BUG #15347: Unaccent for greek characters does not work |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aleksandr Parfenov | 2018-08-28 05:40:32 | Re: Flexible configuration for full-text search |
| Previous Message | Amit Langote | 2018-08-28 04:57:12 | Re: typcache.c typos |