Re: [GENERAL] Upgrade method from 9.2 to 10 ? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] Upgrade method from 9.2 to 10 ?
Date
Msg-id 20170616201831.GA5080@momjian.us
Whole thread Raw
In response to [GENERAL] Upgrade method from 9.2 to 10 ?  (Paul Jones <pbj@cmicdo.com>)
List pgsql-general
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 +


pgsql-general by date:

Previous
From: Paul Jones
Date:
Subject: [GENERAL] Upgrade method from 9.2 to 10 ?
Next
From: melvin6925
Date:
Subject: Re: [GENERAL] Upgrade method from 9.2 to 10 ?