Thread: Upgrading from 6.2 to 7

Upgrading from 6.2 to 7

From
"Sean Weissensee"
Date:
We are planing to upgrade to version 7 of Postgres,
I understand that you cannot use version 6 databases with 7.
 Where can I find information on how to convert these Databases ?
 
Sean
 
Ion Solutions

Re: Upgrading from 6.2 to 7

From
Tom Lane
Date:
"Sean Weissensee" <pginfo@ionsol.com.au> writes:
> We are planing to upgrade to version 7 of Postgres,
> I understand that you cannot use version 6 databases with 7.
>  Where can I find information on how to convert these Databases ?

Short version: pg_dumpall (with old version), initdb, reload.

Long version: Great Bridge's docs explain upgrading in excruciating
detail ;-).  You can download PDFs for free from
http://www.greatbridge.com/docs/
        regards, tom lane