From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Michael Lupo <mikelupo@aol.com>
To: pgsql-admin@postgresql.org
Subject: Re: How to downgrade a cluster from 9.5 to 9.3
Date: Sun, 11 Nov 2018 21:12:45 +0100
Message-ID: <712579a0-724c-bfb0-3118-597f585a16a8@2ndquadrant.com> (raw)
In-Reply-To: <1541863545162-0.post@n3.nabble.com>
References: <1541863545162-0.post@n3.nabble.com>
On 10/11/2018 16:25, Michael Lupo wrote:
> Hello all. My first post.
>
> I have a ubuntu machine that was originally running postgres 9.3. I
> installed 9.5 on that machine as well and then performed a pg_upgradecluster
> -v 9.5. 9.3 main.
> This procedure successfully moved my data from the running 9.3/main cluster,
> to the 9.5/main cluster, brought down the 9.3 running instance and then
> brought the 9.5 instance online utilizing the default ports. This was neat
> to see happen.
>
> As a back out plan, I need to know how to restore the 9.3 running instance
> if for some reason the data got corrupted in the update to 9.5.
You should be able to just shut down the 9.5 instance, switch back the
port numbers, and start the 9.3 instance.
Note that pg_upgradecluster by default uses the pg_dump method, so it's
unlikely that anything will get "corrupted" during the upgrade. It's a
more interesting consideration if you use the pg_upgrade method.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: peter.eisentraut@2ndquadrant.com, mikelupo@aol.com
Subject: Re: How to downgrade a cluster from 9.5 to 9.3
In-Reply-To: <712579a0-724c-bfb0-3118-597f585a16a8@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox