Re: Error Message: FATAL 1: Version number in file '/us

Did you create a database using version 7.0.x?
If so you need to re initdb. This doesn't preserve data however so if you
already have a database you want to preserve you must pg_dump the old one
using postgresql v7.0.x then reload it into 7.1.x (with either psql or
pg_restore depending on dump type).
Hope this helps
- Stuart

> -----Original Message-----
> From:    Markus Meyer [SMTP:meyer@mesw.de]
> Sent:    Monday, October 15, 2001 7:36 PM
> To:    pgsql-cygwin@postgresql.org
> Subject:    [CYGWIN] Error Message: FATAL 1:  Version number in file
> '/usr/local/pgsql/data/PG_VERSION' should be 7.0, not 7.0
>
> when trying to start postgresql on win2000, i get the following error
> messages:
>
> -----------------------------------------------------
> $ ./postgres -D/usr/local/pgsql/data
> DEBUG:  Data Base System is starting up at Mon Oct 15 18:21:44 2001
> DEBUG:  Data Base System was interrupted being in production at Mon Oct 15
> 18:21
> :16 2001
> DEBUG:  Data Base System is in production state at Mon Oct 15 18:21:44
> 2001
> FATAL 1:  Version number in file '/usr/local/pgsql/data/PG_VERSION' should
> be 7.
> 0
> , not 7.0
> .
> FATAL 1:  Version number in file '/usr/local/pgsql/data/PG_VERSION' should
> be 7.
> 0
> , not 7.0
> .
> -----------------------------------------------------
>
> i have read a reply in the archive that says one should use the latest
> version of postgresql and cygwin from the cygwin archive to overcome this
> problem, but i'm already doing that.
>
> please help, i'm stuck.
>
>
> markus
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)