Thread: 8.3 Beta Incompatible Data Disaster
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
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
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
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
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
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
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
--
Mark Walker