Re: upgrade postgres 7.1 to 7.4.2 - Mailing list pgsql-general

From scott.marlowe
Subject Re: upgrade postgres 7.1 to 7.4.2
Date
Msg-id Pine.LNX.4.33.0404201140450.19318-100000@css120.ihs.com
Whole thread Raw
In response to upgrade postgres 7.1 to 7.4.2  ("csysi" <csysi@fe.up.pt>)
List pgsql-general
On Tue, 20 Apr 2004, csysi wrote:

> Hello, i upgrade postgres version 7.1 to version 7.4.2 and it tell me that
> the databases are incompatible.
>
> Can i convert the databases ?

Yes, you need to reinstall 7.1, then use the pg_dump/pg_dumpall from 7.4.2
to dump the data out of the running 7.1 database.  If you setup the two
databases on seperate machines this is easier to do, and how I usually
upgrade Postgresql at work.


pgsql-general by date:

Previous
From: Joe Lester
Date:
Subject: Connection reset by peer
Next
From: jboes@nexcerpt.com (Jeff Boes)
Date:
Subject: Looking for help building 'rhdb-explain' Visual Explain tool