pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to downgrade a cluster from 9.5 to 9.3
3+ messages / 3 participants
[nested] [flat]
* How to downgrade a cluster from 9.5 to 9.3
@ 2018-11-10 15:25 Michael Lupo <mikelupo@aol.com>
2018-11-11 20:12 ` Re: How to downgrade a cluster from 9.5 to 9.3 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Lupo @ 2018-11-10 15:25 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to downgrade a cluster from 9.5 to 9.3
2018-11-10 15:25 How to downgrade a cluster from 9.5 to 9.3 Michael Lupo <mikelupo@aol.com>
@ 2018-11-11 20:12 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
2018-11-13 04:19 ` Re: How to downgrade a cluster from 9.5 to 9.3 Nikhil Shetty <nikhil.dba04@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Peter Eisentraut @ 2018-11-11 20:12 UTC (permalink / raw)
To: Michael Lupo <mikelupo@aol.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to downgrade a cluster from 9.5 to 9.3
2018-11-10 15:25 How to downgrade a cluster from 9.5 to 9.3 Michael Lupo <mikelupo@aol.com>
2018-11-11 20:12 ` Re: How to downgrade a cluster from 9.5 to 9.3 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
@ 2018-11-13 04:19 ` Nikhil Shetty <nikhil.dba04@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Nikhil Shetty @ 2018-11-13 04:19 UTC (permalink / raw)
To: peter.eisentraut@2ndquadrant.com; mikelupo@aol.com; +Cc: pgsql-admin
Hi,
Please take care of custom tablespaces(if you have any) during the
downgrade process using the method mentioned by Peter.
Thanks and Regards
Nikhil
On Mon, Nov 12, 2018 at 3:13 AM Peter Eisentraut <
peter.eisentraut@2ndquadrant.com> wrote:
> 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
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2018-11-13 04:19 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-11-10 15:25 How to downgrade a cluster from 9.5 to 9.3 Michael Lupo <mikelupo@aol.com>
2018-11-11 20:12 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
2018-11-13 04:19 ` Nikhil Shetty <nikhil.dba04@gmail.com>
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