Re: [ADMIN] upgrade path from PG 8.3 to PG 9.5

Поиск
Список
Период
Сортировка
От Thorsten Schöning
Тема Re: [ADMIN] upgrade path from PG 8.3 to PG 9.5
Дата
Msg-id 722763388.20170321172524@am-soft.de
обсуждение исходный текст
Ответ на Re: [ADMIN] upgrade path from PG 8.3 to PG 9.5  (Keith <keith@keithf4.com>)
Ответы Re: [ADMIN] upgrade path from PG 8.3 to PG 9.5  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-admin
Guten Tag Keith,
am Donnerstag, 23. Februar 2017 um 18:57 schrieben Sie:

> You can go directly from 8.3 to 9.5. Just be sure and use the
> pg_dump from 9.5 to generate the dump file from 8.3.

Is there a specific reason for that? My current approach for upgrades
was dumping the old database using the old pg_dump, uninstalling the
old Postgres, installing the new one and restore from the old dump.
That way I didn't accidently mix-up installations or use wrong tools
or such.

Did pg_dump have bugs in the past which resulted in pg_restore not
being able to read the dumps?

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning       E-Mail: Thorsten.Schoening@AM-SoFT.de
AM-SoFT IT-Systeme      http://www.AM-SoFT.de/

Telefon...........05151-  9468- 55
Fax...............05151-  9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow



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

Предыдущее
От: Poul Kristensen
Дата:
Сообщение: Re: [ADMIN] Postgres - Replication
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: [ADMIN] upgrade path from PG 8.3 to PG 9.5