RE: CVS, initdb and catalog version

From: "Ryan C(dot) Bonham" <Ryan(at)srfarms(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: RE: CVS, initdb and catalog version
Date: 2001-05-18 13:04:33
Message-ID: 19AB8F9FA07FB0409732402B4817D75A03892E@FILESERVER.SRF.srfarms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I think you just need to do a dump of the database, and then import it back
in after you update your source... I could be wrong, i havn't had my coffee
yet...

-----Original Message-----
From: Laurent Duperval [mailto:lduperval(at)microcelli5(dot)com]
Sent: Tuesday, May 15, 2001 9:40 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] CVS, initdb and catalog version

Hi,

I updated my source code from CVS and it looks like it creates a problem
because now, the server won't come up because of this error:

Starting postgresql service: + su -l postgres -c '/usr/local/bin/pg_ctl -D
/usr/local/var/lib/pgsql/data -o -i -p /usr/local/bin/postmaster start'
postmaster successfully started
FATAL 2: database was initialized with CATALOG_VERSION_NO 200105101,
but the backend was compiled with CATALOG_VERSION_NO 200105145.
looks like you need to initdb.

and then:

initdb: The directory /usr/local/var/lib/pgsql/data exists but is not empty.
If you want to create a new database system, either remove or empty
the directory /usr/local/var/lib/pgsql/data or run initdb with
an argument other than /usr/local/var/lib/pgsql/data.

So does that mean that every time I update the CVS code I have to trash
my existing data? Not that it's really a problem yet, mind you. When I
have real data that I need to keep, I'll move to 7.1.1.

L

--
Laurent Duperval <mailto:lduperval(at)microcelli5(dot)com>

La situation se cornélise à vue d'oeil!
-Alambic Talon

---------------------------(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)

Browse pgsql-general by date

  From Date Subject
Next Message Len Morgan 2001-05-18 13:08:02 Re: SELECT from a table in another database
Previous Message Laurent Duperval 2001-05-18 12:24:46 Re: rotate sql.log