Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres UPGRADE from 9.2 to 9.4 - Mailing list pgsql-general

From Patrick B
Subject Re: Postgres UPGRADE from 9.2 to 9.4
Date
Msg-id CAJNY3ivETAt0MojW18UbDzBVJx8R=LQtJrbbV7RZZ-0m9q_kbg@mail.gmail.com
Whole thread Raw
In response to Re: Postgres UPGRADE from 9.2 to 9.4  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: Postgres UPGRADE from 9.2 to 9.4  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view

John,
Yes, Rackspace supports slony. I used to work there and they use slony on their core system.

Patrick,
You cannot stream directly from 9.2 to 9.4. However, you can just create a separate 9.4 cluster (on a separate port).
Then pg_dump from 9.2 in plain format and it will load on 9.4


damn!!! really? =( That's not good

will have to think about how will perform this....

I think  what I would need to use is:


1 - upgrade master server
2 - by performing #1 - the slaves would become unused (streaming replication wouldn't work)
3 - Setup new slave running Postgres 9.4
4 - dump the db to the new server


Do you guys agree? 

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Postgres UPGRADE from 9.2 to 9.4
Next
From: John R Pierce
Date:
Subject: Re: Postgres UPGRADE from 9.2 to 9.4