How to downgrade a cluster from 9.5 to 9.3

From: Michael Lupo <mikelupo(at)aol(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to downgrade a cluster from 9.5 to 9.3
Date: 2018-11-10 15:25:45
Message-ID: 1541863545162-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Does anyone have experience doing this and if so, how did you accomplish?

Thank you in advance.

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2018-11-11 20:09:07 Re: Modules but not extensions
Previous Message Ron 2018-11-10 10:08:17 Modules but not extensions