Best way to migrate a 200 GB database from PG 2.7 to 3.6

Поиск
Список
Период
Сортировка
От Filip Lyncker
Тема Best way to migrate a 200 GB database from PG 2.7 to 3.6
Дата
Msg-id 552EB5F7.3040706@lyth.de
обсуждение исходный текст
Ответы Re: Best way to migrate a 200 GB database from PG 2.7 to 3.6  (Raymond O'Donnell <rod@iol.ie>)
Re: Best way to migrate a 200 GB database from PG 2.7 to 3.6  (Igor Neyman <ineyman@perceptron.com>)
Re: Best way to migrate a 200 GB database from PG 2.7 to 3.6  (Andy Colson <andy@squeakycode.net>)
Список pgsql-general
Дерево обсуждения 
Dear List,

I need to migrate my database from a 2.x to 3.x. Usually Im using
pg_basebackup , but this is not possible with different versions.
Pg_dump seems to be an option but it is slow like hell and I dont want
to stay offline all the time.
Is there another possibility to migrate  a database with 200 GB ?

Thanks a lot,

cheers

Filip

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

Предыдущее
От: Pawel Veselov
Дата:
Сообщение: Re: Help with slow table update
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Best way to migrate a 200 GB database from PG 2.7 to 3.6