Re: upgrade postgres 7.1 to 7.4.2

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: csysi <csysi(at)fe(dot)up(dot)pt>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: upgrade postgres 7.1 to 7.4.2
Date: 2004-04-20 17:41:42
Message-ID: Pine.LNX.4.33.0404201140450.19318-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2004-04-20 17:44:37 Re: convert result to uppercase
Previous Message Peter Lang 2004-04-20 17:28:25 Re: Vb databound