Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrading from 6.2 to 7 - Mailing list pgsql-sql

From Tom Lane
Subject Re: Upgrading from 6.2 to 7
Date
Msg-id 5302.985706656@sss.pgh.pa.us
Whole thread Raw
In response to Upgrading from 6.2 to 7  ("Sean Weissensee" <pginfo@ionsol.com.au>)
List pgsql-sql
Tree view 
"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

pgsql-sql by date:

Previous
From: Andy Corteen
Date:
Subject: Re: Re: Still don't know how to build this string ? how to concat ??
Next
From: Andy Corteen
Date:
Subject: Re: Re: Still don't know how to build this string ? how to concat ??