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 ?
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 +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
