[postgis-users] Database initialisation

[Tyler Mitchell]

Good challenging opportunity for you :)
Install the old version of the database (and postgis, etc.) as per normal, 
on a local copy of cygwin (i.e. that you control :).  Then copy your data 
folder over to your setup and start postgresql using that data folder. 
Then do a dump of the database (ask again if you need help with that) to a 
file.  Don't try to restart your broken db, but initialize it, create a 
database and load the dump file into the database.  Enjoy.  pgadmin may 
have some tools to help go from 7.3 -> 7.4.1 directly rather than to file.

Tyler

postgis-users-bounces at postgis.refractions.net wrote on 04/04/2004 01:58:51 
PM:

> Hello
> 
> Someone has upgraded my postgres database on cygwin. The result is that
> my database won't start.
> 
> FATAL:  database files are incompatible with server
> DETAIL:  The data directory was initialized by PostgreSQL version 7.3,
> which is
> not compatible with this version 7.4.1.
> 
> Any idea of a quick, easy fix ?
> 
> Thanks
> 
> Chris
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users