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
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
Show quoted text
--
Mark Walker
Hi,
On Thu, 2008-01-10 at 11:36 +0000, Mark Walker wrote:
Any help appreciated, including links to a download of beta1 that
still works.
/me thinks that we should also keep beta versions at the ftp-archives
site , at least for a reasonable time.
Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/
Devrim G�ND�Z wrote:
Hi,
On Thu, 2008-01-10 at 11:36 +0000, Mark Walker wrote:
Any help appreciated, including links to a download of beta1 that
still works./me thinks that we should also keep beta versions at the ftp-archives
site , at least for a reasonable time.
Agreed.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Alvaro Herrera <alvherre@CommandPrompt.com> writes:
Devrim G�ND�Z wrote:
/me thinks that we should also keep beta versions at the ftp-archives
site , at least for a reasonable time.
Agreed.
At least the last one prior to any forced initdb.
regards, tom lane
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