Thread: The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.3.
The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.3.
From
"Bilicki Vilmos"
Date:
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
Re: The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.3.
From
Bruno Wolff III
Date:
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.
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/static/install-upgrading.html