Re: Postgres DB Migration from 8.3 to 9.1

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Postgres DB Migration from 8.3 to 9.1
Дата
Msg-id CAOR=d=0po_a931G44e1hWjMp-QU-=JZ_bbrn_MAxNv1CuKBm3g@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres DB Migration from 8.3 to 9.1  (Vishalakshi Navaneethakrishnan <nvishalakshi@sirahu.com>)
Ответы Re: Postgres DB Migration from 8.3 to 9.1  (Vishalakshi Navaneethakrishnan <nvishalakshi@sirahu.com>)
Список pgsql-general
On Thu, Oct 11, 2012 at 8:15 PM, Vishalakshi Navaneethakrishnan
<nvishalakshi@sirahu.com> wrote:
> 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..?

As downtime required approaches zero, the likelyhood of needing slony
approaches 1.


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

Предыдущее
От: Thalis Kalfigkopoulos
Дата:
Сообщение: tablespace_oid alias?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: tablespace_oid alias?