On Thu, Jan 10, 2008 at 11:36:04AM +0000, Mark Walker wrote:
> 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.
You can get the beta1 source out of the cvs repository (see instructions in
the documentation, you want the tag REL8_3_BETA1)
//Magnus
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
