Re: The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.3. - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.3.
Date
Msg-id 20041023232755.GC11915@wolff.to
Whole thread Raw
In response to The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.3.  ("Bilicki Vilmos" <bilickiv@inf.u-szeged.hu>)
List pgsql-general
On Sat, Oct 23, 2004 at 10:10:41 +0200,
  Bilicki Vilmos <bilickiv@inf.u-szeged.hu> wrote:
> Hi all,
>
> I have upgraded my cygwin installation and it has replaced my old 7.3
> postgresql.
>
> My questions are the following:
>
> How can I use the old files with the newer version?
> If this is not possible, how can I migrate my database to a newer version
> without the old database engine?
> If this is not possible how can I downgrade the postgresql to an appropriate
> version? (The setup utility provides only the 7.4 version)
>
> Many thanks for helping me,

The normal procedure is to do a dump before shutting the current server
down (though using the newer pg_dumpall client is recommended if you
both the new and old versions installed at the same time). Then after
shutting the old server down and starting the new one up, you import
the dump file.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: '1 year' = '360 days' ????
Next
From: Bruno Wolff III
Date:
Subject: Comment on timezone and interval types