Thread: 8.3 Beta Incompatible Data Disaster

8.3 Beta Incompatible Data Disaster

From
"Mark Walker"
Date:
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

Re: 8.3 Beta Incompatible Data Disaster

From
Magnus Hagander
Date:
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

Re: 8.3 Beta Incompatible Data Disaster

From
Alvaro Herrera
Date:
Mark Walker escribió:
> 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.

You can grab the 8.3 beta 1 sources using the CVS repository and the tag
REL8_3_BETA1.


--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Re: 8.3 Beta Incompatible Data Disaster

From
"Joshua D. Drake"
Date:
Mark Walker wrote:

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

Ugh, that is a bummer and you are right. They are not on our mirrors.
Nor are the packages on our ftp-archives server.

If you are comfortable with svn you could do this:

svn co -r 29250 https://projects.commandprompt.com/public/pgsql/repo beta1

Sincerely,

Joshua D. Drake



>
> --
>
> Mark Walker


Re: 8.3 Beta Incompatible Data Disaster

From
Shane Ambler
Date:
Joshua D. Drake wrote:
> Mark Walker wrote:
>
>> 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.
>
> Ugh, that is a bummer and you are right. They are not on our mirrors.
> Nor are the packages on our ftp-archives server.
>
> If you are comfortable with svn you could do this:
>
> svn co -r 29250 https://projects.commandprompt.com/public/pgsql/repo beta1
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>>
>> --
>>
>> Mark Walker

Was it beta2 that changed the structure or beta3?

Anyway worst case I still have a beta1 source tarball here if you need it.


--

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz

Re: 8.3 Beta Incompatible Data Disaster

From
"Mark Walker"
Date:
The cvs/svn worked I managed to dump out of beta 1 and now have my database restored in RC1. Many thanks to all.

--

Mark Walker