Thread: [GENERAL] Upgrade method from 9.2 to 10 ?
Would it be possible to upgrade from 9.2 to 10 by doing a pg_basebackup to the new server, followed by pg_upgrade -k, then streaming replication from the 9.2 server to the 10 server until we're ready to cut over to 10? The idea is to minimize downtime. PJ
On Fri, Jun 16, 2017 at 04:14:07PM -0400, Paul Jones wrote: > Would it be possible to upgrade from 9.2 to 10 by doing a pg_basebackup > to the new server, followed by pg_upgrade -k, then streaming replication > from the 9.2 server to the 10 server until we're ready to cut over to 10? > > The idea is to minimize downtime. You can't use streaming replication between different major versions. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +
You can use Slony to replicate between different major versions.
Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone
-------- Original message --------
From: Bruce Momjian <bruce@momjian.us>
Date: 6/16/17 16:18 (GMT-05:00)
To: Paul Jones <pbj@cmicdo.com>
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Upgrade method from 9.2 to 10 ?
> Would it be possible to upgrade from 9.2 to 10 by doing a pg_basebackup
> to the new server, followed by pg_upgrade -k, then streaming replication
> from the 9.2 server to the 10 server until we're ready to cut over to 10?
>
> The idea is to minimize downtime.
You can't use streaming replication between different major versions.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general