Upgrade method from 9.2 to 10 ?

From: Paul Jones <pbj(at)cmicdo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Upgrade method from 9.2 to 10 ?
Date: 2017-06-16 20:14:07
Message-ID: 20170616201407.GA4756@cmicdo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2017-06-16 20:18:31 Re: Upgrade method from 9.2 to 10 ?
Previous Message Adrian Klaver 2017-06-16 12:46:48 Re: Missing folder rhel-6Workstation-x86_64 for 9.6 repo (redhat)