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(at)mesw(dot)de]
> Sent: Monday, October 15, 2001 7:36 PM
> To: pgsql-cygwin(at)postgresql(dot)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(at)postgresql(dot)org)