pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Rui DeSousa <rui@crazybean.net>
To: Don Seiler <don@seiler.us>
Cc: Ian Lawrence Barwick <barwick@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Recovery from WAL archives not advancing timeline?
Date: Mon, 10 Aug 2020 20:23:53 -0400
Message-ID: <457D6CE0-90BE-4F88-87FB-A950F6C40AE5@crazybean.net> (raw)
In-Reply-To: <8C31D73B-BD43-42FC-A8C5-87DA351BA155@crazybean.net>
References: <CAHJZqBBk1cgbvXevUuAGTsbMTYx6_BDwwUqV_4ne_QUG=AuMmw@mail.gmail.com>
	<CAB8KJ=iQWTop4Ekb1XaKCBm4RU0Jpqte6vUKH3E0BGZvS5Ukfg@mail.gmail.com>
	<CAHJZqBDVajF1zuVbomNL=Jp2QkoFN4uNxnsMZdvw8b-v7D1DBQ@mail.gmail.com>
	<CAB8KJ=jsEKz6GY0d+bi6Q2_U5_GDSJkaOO8Mh2V+rQ-JHM6_vg@mail.gmail.com>
	<CAHJZqBB-TXuPS4R2M9N0mHSQUc8OjNwCkttE4q21-Cskhe+kbg@mail.gmail.com>
	<CAHJZqBD27noE2apUEQG=2+MXDwc2538-H1S+qPek3aXyawPg3w@mail.gmail.com>
	<CAHJZqBAH0cg9qMzUteyvJqJBbAFyY5y84P-kJTgcYQkXi+bcAQ@mail.gmail.com>
	<CAHJZqBB5X37hGJJyUR2QG-NHqjUnQVTVcWxRk0Yjwsi=tpxv+Q@mail.gmail.com>
	<8C31D73B-BD43-42FC-A8C5-87DA351BA155@crazybean.net>



> On Aug 10, 2020, at 8:03 PM, Rui DeSousa <rui@crazybean.net> wrote:
> 
> 
> 
>> On Aug 10, 2020, at 4:28 PM, Don Seiler <don@seiler.us <mailto:don@seiler.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. 
> 

Just to be clear if it wasn’t already self evident by my above statement: The primary needs to be clearly shutdown (all WALs archived), apply all WALs to replica, promote the replica and then the original primary can be turn into a replica without a restore or pg_rewind. =

view thread (12+ messages)  latest in thread

Message-ID: <457D6CE0-90BE-4F88-87FB-A950F6C40AE5@crazybean.net>
Permalink:  ../457D6CE0-90BE-4F88-87FB-A950F6C40AE5@crazybean.net/
Also on:    postgresql.org/message-id/457D6CE0-90BE-4F88-87FB-A950F6C40AE5@crazybean.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: rui@crazybean.net, don@seiler.us, barwick@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Recovery from WAL archives not advancing timeline?
  In-Reply-To: <457D6CE0-90BE-4F88-87FB-A950F6C40AE5@crazybean.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox