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 00:03:54
Message-ID: 8C31D73B-BD43-42FC-A8C5-87DA351BA155@crazybean.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Aug 10, 2020, at 4:28 PM, Don Seiler <don(at)seiler(dot)us> wrote:
>
> I'm following up to see if anyone else would categorize this as a bug. It renders my old primaries dead until I do a restore on them.

No, I don’t think so. When you promote a standby; the primary will have to be restored or rewinded using pg_rewind to turn it into a replica. Another approach is to cleanly shutdown the primary and then you can turn it into a replica without doing a restore or pg_rewind.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2020-08-11 00:23:53 Re: Recovery from WAL archives not advancing timeline?
Previous Message Don Seiler 2020-08-10 20:28:34 Re: Recovery from WAL archives not advancing timeline?