Re: pg_upgrade

Поиск
Список
Период
Сортировка
От Jan Lentfer
Тема Re: pg_upgrade
Дата
Msg-id e84cbc3cee08d8569cd670860c2b1900@imap.lan.net
обсуждение исходный текст
Ответ на pg_upgrade  (Rainer Leo <leo@workfile.de>)
Ответы Re: pg_upgrade  (Ziggy Skalski <zskalski@afilias.info>)
Re: pg_upgrade  (Catalin Iacob <iacobcatalin@gmail.com>)
Список pgsql-admin
Am 2015-06-22 11:14, schrieb Rainer Leo:
> pg_upgrade Hello,
>
>  we are still using PostgreSQL 9.0.2 on Windows Server.
>
>  Now we are migrating to Windows Server 2012 R2 and we
>  would like to migrate PostgreSQL at the same time to
>  the current version 9.4.4-1
>
>  Which is the best way to migrate the data?
>
>  1. pg_dump on the old server
>  2. pg_retore on the new server
>  3. pg_upgrade on the new server
>
>  Is this correct or is there a "best procedure" to do this?

You do either 1 + 2 OR 3. pg_upgrade is binary upgrade, where as
pg_dump + pg_restore is "logical" (dump data and schemal to SQL
instructions). If you go that way also check pg_dumpall for dumping the
globals.


Regards

Jan



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

Предыдущее
От: Rainer Leo
Дата:
Сообщение: pg_upgrade
Следующее
От: Ziggy Skalski
Дата:
Сообщение: Re: pg_upgrade