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
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 |
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? |