What is the best plan to upgrade PostgreSQL from an ancient version?

Поиск
Список
Период
Сортировка
От Dann Corbit
Тема What is the best plan to upgrade PostgreSQL from an ancient version?
Дата
Msg-id D425483C2C5C9F49B5B7A41F8944154702961F75@postal.corporate.connx.com
обсуждение исходный текст
Ответы Re: What is the best plan to upgrade PostgreSQL from an ancient version?  (Raymond O'Donnell <rod@iol.ie>)
Re: What is the best plan to upgrade PostgreSQL from an ancient version?  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: What is the best plan to upgrade PostgreSQL from an ancient version?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: What is the best plan to upgrade PostgreSQL from an ancient version?  (marcin mank <marcin.mank@gmail.com>)
Список pgsql-general
Дерево обсуждения 
My notion is to do a character mode database dump as SQL statements and
then load into the new version by execution of psql against the sql
STATEMENTS.

What are the "gotchas" we can expect with this approach?

When I say 'ancient' I mean v7.1.3 and the target is v8.3.5.

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

Предыдущее
От: "Bernard Grosperrin"
Дата:
Сообщение: Please, could I subscribe to this list? Thanks.
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: What is the best plan to upgrade PostgreSQL from an ancient version?