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

help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: [External] Re: WAL Replication query
Date: Tue, 1 Nov 2022 09:06:24 -0500
Message-ID: <e94d85cc-b0c9-9aea-8f7e-2ba3d6ac31bc@gmail.com> (raw)
In-Reply-To: <cff94aa50765b00e798d15a5419830c82f8049ec.camel@cybertec.at>
References: <CAKgGyB-SMT0RxeoifAfjkRx6RHEOgpn7sf8F_zD1DPsKydTu=w@mail.gmail.com>
	<88faef33e966796226022d6e7f3e32ad6c59fcfd.camel@cybertec.at>
	<MW4PR20MB4525ED0222DDE9FED0519D8FF3369@MW4PR20MB4525.namprd20.prod.outlook.com>
	<c1b6b89d6b89706acaeca9b4d45958f4739c4f28.camel@cybertec.at>
	<8f9e6c92-4daa-a543-6825-05a3503f4296@gmail.com>
	<f78c361061449be8402922cd5ed7f5782f65aab1.camel@cybertec.at>
	<42306ea2-74c2-a95e-551d-e1d16946c083@gmail.com>
	<cff94aa50765b00e798d15a5419830c82f8049ec.camel@cybertec.at>

On 11/1/22 08:56, Laurenz Albe wrote:
> On Tue, 2022-11-01 at 08:49 -0500, Ron wrote:
>> Primary has crashed, according to OP; it's not coming back any time soon.  And thus you promote
>> Secondary to be New Primary, and go about  your work.  When the Old Primary comes back up
>> (hours or days later), you do a pg_basebackup to make it the New Secondary.
> There was no word about failover

On of the purposes of replication is so that you can fail over to it when 
Primary crashes, right?

> or "not coming back any time soon" (that's why I asked for
> clarification in my answer).

It does of course depend on what crashes, and how long it takes to restart.

Just the other day, Veeam somehow (for at least the second time) broke all 
connections *to a VM* running under ESX.  It took six hours to get fixed.  
That VM was running Postgresql.  If the Pg cluster was replicated, I'd have 
promoted the Secondary to Primary for my customer.

-- 
Angular momentum makes the world go 'round.

view thread (15+ messages)  latest in thread

Message-ID: <e94d85cc-b0c9-9aea-8f7e-2ba3d6ac31bc@gmail.com>
Permalink:  ../e94d85cc-b0c9-9aea-8f7e-2ba3d6ac31bc@gmail.com/
Also on:    postgresql.org/message-id/e94d85cc-b0c9-9aea-8f7e-2ba3d6ac31bc@gmail.com

 · 

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: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: [External] Re: WAL Replication query
  In-Reply-To: <e94d85cc-b0c9-9aea-8f7e-2ba3d6ac31bc@gmail.com>

* 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