Postgres DB Migration from 8.3 to 9.1

Поиск
Список
Период
Сортировка
От Vishalakshi Navaneethakrishnan
Тема Postgres DB Migration from 8.3 to 9.1
Дата
Msg-id CAP-PUP3-xbZ9O9BDm+sA9B07gW9hqG5j6n-Sd+n2GLbXh9p0gg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Postgres DB Migration from 8.3 to 9.1  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: Postgres DB Migration from 8.3 to 9.1  (John R Pierce <pierce@hogranch.com>)
Re: Postgres DB Migration from 8.3 to 9.1  (Amitabh Kant <amitabhkant@gmail.com>)
Re: Postgres DB Migration from 8.3 to 9.1  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi Friends,

We have our production environment database server in Postgres 8.3 version. we have planned to upgrade to lastest version 9.1. Dump from 8.3  and restore in Postgres 9.1 takes more than 5 hours. Any other quick method to upgrade from 8.3 to 9.1. We need to reduce our downtime  below 1 hour. Any Possibilities..?

Thanks in Advance.

--
Best Regards,
Vishalakshi.N

В списке pgsql-general по дате отправления:

Предыдущее
От: Thalis Kalfigkopoulos
Дата:
Сообщение: AS s(a) vs. AS a
Следующее
От: Tom Lane
Дата:
Сообщение: Re: AS s(a) vs. AS a