Postgres Pro
Downloads
Home   >   mailing lists

What is the best plan to upgrade PostgreSQL from an ancient version? - Mailing list pgsql-general

From Dann Corbit
Subject What is the best plan to upgrade PostgreSQL from an ancient version?
Date
Msg-id D425483C2C5C9F49B5B7A41F8944154702961F75@postal.corporate.connx.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view 
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 by date:

Previous
From: "Bernard Grosperrin"
Date:
Subject: Please, could I subscribe to this list? Thanks.
Next
From: Raymond O'Donnell
Date:
Subject: Re: What is the best plan to upgrade PostgreSQL from an ancient version?