Re: Postgres UPGRADE from 9.2 to 9.4

Поиск
Список
Период
Сортировка
От Patrick B
Тема Re: Postgres UPGRADE from 9.2 to 9.4
Дата
Msg-id CAJNY3ivETAt0MojW18UbDzBVJx8R=LQtJrbbV7RZZ-0m9q_kbg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres UPGRADE from 9.2 to 9.4  (Melvin Davidson <melvin6925@gmail.com>)
Ответы Re: Postgres UPGRADE from 9.2 to 9.4  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Дерево обсуждения

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 по дате отправления:

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: Postgres UPGRADE from 9.2 to 9.4
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Postgres UPGRADE from 9.2 to 9.4