The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.3.

[Bilicki Vilmos]

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,

Vilmos
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Bruno Wolff III]

On Sat, Oct 23, 2004 at 10:10:41 +0200,
Bilicki Vilmos <bi******@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.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[stig erikson]

Bilicki Vilmos 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,

Vilmos
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

see:
http://www.postgresql.org/docs/7.4/s...upgrading.html