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

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: What is the best plan to upgrade PostgreSQL from an ancient version?
Date: 2009-01-26 21:37:48
Message-ID: D425483C2C5C9F49B5B7A41F8944154702961F75@postal.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2009-01-26 21:42:14 Re: What is the best plan to upgrade PostgreSQL from an ancient version?
Previous Message Bernard Grosperrin 2009-01-26 21:20:44 Please, could I subscribe to this list? Thanks.