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

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