Re: pg_rewind issue

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: James Sewell <james(dot)sewell(at)jirotech(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_rewind issue
Date: 2017-09-18 08:22:29
Message-ID: CAB7nPqQ86+0QT2uD2sKS_L3FODmRR+0x+p-cYaJPEfbJUZjY_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Sep 18, 2017 at 1:36 PM, James Sewell <james(dot)sewell(at)jirotech(dot)com> wrote:
> When Iook at timeline 15 I see this:
>
> 20 C74/45000000 no recovery target specified+

This refers to timeline 20. Are there other entries in this history
file? Isn't timeline 15 a direct parent of timeline 20?

> As 0000001500000C73000000A9 > 0000001500000C7400000044 I'm confused why
> this WAL would be required? It's never been created on either server
> (although the same suffix does exist in timeline 14).

Your math is incorrect here. For me 0000001500000C73000000A9 <
0000001500000C7400000044, C73 being generated *before* C74.

> The contents of this email are confidential and may be subject to legal or
> professional privilege and copyright. No representation is made that this
> email is free of viruses or other defects. If you have received this
> communication in error, you may not copy or distribute any part of it or
> otherwise disclose its contents to anyone. Please advise the sender of your
> incorrect receipt of this correspondence.

The contents of this mailing list are public.
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Berend Tober 2017-09-18 11:59:23 Re: Selecting a daily puzzle record - which type of column to add?
Previous Message milist ujang 2017-09-18 08:00:48 Re: BDR, near xid wraparound, a lot of files in pg_subtrans directory