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 <br...@momjian.us> Date: 6/16/17 16:18 (GMT-05:00) To: Paul Jones <p...@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 <br...@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
