8.3 Beta Incompatible Data Disaster

From: "Mark Walker" <markrjgwalker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 8.3 Beta Incompatible Data Disaster
Date: 2008-01-10 11:36:04
Message-ID: 5c9611e90801100336u2aaad4fdx785781410f6a2052@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-www

Ignoring the warnings not to use a beta product on a production database I
had been running 8.3beta1. When I saw that it had hit 8.3RC1 I decided to
upgrade and folowing the usual data compatibility within major versions I
did not do a pg_dump, in fact my last dump was when I loaded the beta on
10th October. I get the following error
FATAL: database files are incompatible with server
Unfortunately, I cannot find my copy of the beta1 source files and they are
no longer available on the internet. All I had was a download of beta4,
which I never used. I fired it up hoping that the data incompatibility was
between beta and RC, but the error reads:
FATAL: database files are incompatible with server
DETAIL: The database cluster was initialized with CATALOG_VERSION_NO
200709301, but the server was compiled with CATALOG_VERSION_NO 200711281.

What can I do, a dump is impossible because I cannot re-install the version
that the database was last used with (it should have been first initialised
on 8.2, as I went to the beta to experiment with enum having recently
returned from MySQL).

Any help appreciated, including links to a download of beta1 that still
works.

--

Mark Walker

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-01-10 11:39:02 Re: Kernel kills postgres process - help need
Previous Message dformenton 2008-01-10 11:14:48 Re: Increase the number of concurrent connection

Browse pgsql-www by date

  From Date Subject
Next Message Magnus Hagander 2008-01-10 14:49:31 Re: 8.3 Beta Incompatible Data Disaster
Previous Message Dave Page 2008-01-09 20:10:40 Re: Events Disconnect?