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

help / color / mirror / Atom feed

From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Ebin Jozer <ebinjozer@gmail.com>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Postgresql community edition upgrade
Date: Thu, 13 Oct 2022 06:51:53 -0600
Message-ID: <3DEF677C-D70F-43F5-A912-4DA0C8C949D3@elevated-dev.com> (raw)
In-Reply-To: <CAJuN1jj_QZTSwdHmA3SFC84EpXLm5mEC3awpg5PQaemY8CWB5Q@mail.gmail.com>
References: <CAJuN1jj9=x5FPUypuCGntG82mbZQbW-XOWgbg+H97MrwZ20wLA@mail.gmail.com>
	<7ce8278e-f943-74d4-ca73-cbf9e422f784@jakobs.com>
	<CAJuN1jiQ+nUMkay00SSS-axrOBrCL4QoYhRp6sWWdS_S4OHwRg@mail.gmail.com>
	<9571D051-5B4F-45FB-A52B-9D84C601B7DC@elevated-dev.com>
	<183cdeb4338.2923.9bfe8bcc586ac955e423c0e3d5444448@pscs.co.uk>
	<CAJuN1jj_QZTSwdHmA3SFC84EpXLm5mEC3awpg5PQaemY8CWB5Q@mail.gmail.com>

> On Oct 13, 2022, at 3:42 AM, Ebin Jozer <ebinjozer@gmail.com> wrote:
> 
> We have master and slave environment. So for upgrade we have upgrade first in slave and then in master environment. Please confirm

Depends on your HA requirements.

Easiest: shut down primary and all db access, upgrade one, bring it back up as primary, upgrade other and bring it back online as replica.

Harder: use a replication scheme that works across versions (publish/subscribe, pglogical, londiste, bucardo) so that you can bring up a new replica on the new version, switch over to it with minimal downtime (just enough to make sure changes from master have been replicated), then turn the former primary into a new  replica.

view thread (8+ messages)

Message-ID: <3DEF677C-D70F-43F5-A912-4DA0C8C949D3@elevated-dev.com>
Permalink:  ../3DEF677C-D70F-43F5-A912-4DA0C8C949D3@elevated-dev.com/
Also on:    postgresql.org/message-id/3DEF677C-D70F-43F5-A912-4DA0C8C949D3@elevated-dev.com

copy link · copy postgr.es

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: scott_ribe@elevated-dev.com, ebinjozer@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Postgresql community edition upgrade
  In-Reply-To: <3DEF677C-D70F-43F5-A912-4DA0C8C949D3@elevated-dev.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