Skip site navigation (1) Skip section navigation (2)

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

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: "'Markus Meyer'" <meyer(at)mesw(dot)de>, pgsql-cygwin(at)postgresql(dot)org
Subject: Re: Error Message: FATAL 1: Version number in file '/us
Date: 2001-10-30 09:12:16
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F7470C@MAIL_EXCHANGE (view raw or flat)
Thread:
Lists: pgsql-cygwin
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)

pgsql-cygwin by date

Next:From: Giuliano CastelliDate: 2001-10-30 22:47:00
Subject: problem with cygipc
Previous:From: Henshall, Stuart - WCPDate: 2001-10-30 09:09:50
Subject: Re: PostgreSQL, cygipc question - Seems to be cygwin1.dl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group