Lists: | pgsql-general |
---|
From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
---|---|
To: | jd(at)commandprompt(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: was a initdb required from 8.1beta3 -> beta4? |
Date: | 2005-12-02 21:43:57 |
Message-ID: | 4390C01D.6030908@amsoftwaredesign.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Joshua D. Drake wrote
>> .
>>
>
> Install beta3, backup, install 8.1 restore.
>
>
That's what I wanted to do but I can't seem to find a beta3 tar.gz
anywhere, the downloads only go to beta4 :-(
Tony
From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | was a initdb required from 8.1beta3 -> beta4? |
Date: | 2005-12-02 22:03:27 |
Message-ID: | 4390C4AF.90208@amsoftwaredesign.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Hi,
I messed up and updated my beta3 to 8.1 and didn't realize a initdb was
required.
Is there anyway I can get at the data? It's on Gentoo and the
/var/lib/postgresql/data dir is still intact.
I tried to install beta4 but got the this error:
FATAL: database files are incompatible with server
DETAIL: The database cluster was initialized with CATALOG_VERSION_NO
200510051, but the server was compiled with CATALOG_VERSION_NO 200510211.
HINT: It looks like you need to initdb.
Thanks,
Tony
From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: was a initdb required from 8.1beta3 -> beta4? |
Date: | 2005-12-02 22:08:43 |
Message-ID: | 1133561323.26607.4.camel@jd.commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Fri, 2005-12-02 at 16:03 -0600, Tony Caduto wrote:
> Hi,
> I messed up and updated my beta3 to 8.1 and didn't realize a initdb was
> required.
> Is there anyway I can get at the data? It's on Gentoo and the
> /var/lib/postgresql/data dir is still intact.
Install beta3, backup, install 8.1 restore.
>
> I tried to install beta4 but got the this error:
>
> FATAL: database files are incompatible with server
> DETAIL: The database cluster was initialized with CATALOG_VERSION_NO
> 200510051, but the server was compiled with CATALOG_VERSION_NO 200510211.
> HINT: It looks like you need to initdb.
>
> Thanks,
>
> Tony
>
> ---------------------------(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
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl, ODBCng - http://www.commandprompt.com/
From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | jd(at)commandprompt(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: was a initdb required from 8.1beta3 -> beta4? |
Date: | 2005-12-02 22:18:53 |
Message-ID: | 4390C84D.8060407@amsoftwaredesign.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Tom Lane wrote:
> If you don't find a tarball, you could pull the beta3 tag from CVS.
> See http://developer.postgresql.org/docs/postgres/cvs.html
> The tag you want is REL8_1_0BETA3 ... too lazy to check the cvs
> man page, but I think you would add "-r REL8_1_0BETA3" to the
> normal cvs checkout command.
>
> regards, tom lane
>
>
Thanks Tom,
I will give that a go.
Tony
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
Cc: | jd(at)commandprompt(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: was a initdb required from 8.1beta3 -> beta4? |
Date: | 2005-12-03 03:49:57 |
Message-ID: | 11305.1133581797@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> writes:
>> Install beta3, backup, install 8.1 restore.
> That's what I wanted to do but I can't seem to find a beta3 tar.gz
> anywhere, the downloads only go to beta4 :-(
If you don't find a tarball, you could pull the beta3 tag from CVS.
See http://developer.postgresql.org/docs/postgres/cvs.html
The tag you want is REL8_1_0BETA3 ... too lazy to check the cvs
man page, but I think you would add "-r REL8_1_0BETA3" to the
normal cvs checkout command.
regards, tom lane