Re: Recovery from WAL archives not advancing timeline?

From: Rui DeSousa <rui(at)crazybean(dot)net>
To: Don Seiler <don(at)seiler(dot)us>
Cc: Ian Lawrence Barwick <barwick(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Recovery from WAL archives not advancing timeline?
Date: 2020-08-11 01:30:13
Message-ID: B7FEA443-465B-4162-86BB-2337F1D5F8D2@crazybean.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Aug 10, 2020, at 8:58 PM, Don Seiler <don(at)seiler(dot)us> wrote:

> This process was the same for both streaming and non-streaming replication. However only the streaming replica wrote a .partial WAL file on promotion (which was then archived and used by the former primary to start recovery). The former primary doesn't even try to follow the timeline change in the non-streaming scenario.
>

It would not create a partial WAL as it was not streaming thus is no partial data to archive.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2020-08-11 08:33:05 Re: PostgreSQL JDBC Driver ERROR: invalid byte sequence for encoding "UTF8": 0x00 on Select stmt
Previous Message Ian Barwick 2020-08-11 01:08:23 Re: Recovery from WAL archives not advancing timeline?