was a initdb required from 8.1beta3 -> beta4?

Started by Tony Cadutoalmost 21 years ago5 messagesgeneral
Jump to latest
#1Tony Caduto
tony_caduto@amsoftwaredesign.com
In reply to: Joshua D. Drake (#3)
Re: was a initdb required from 8.1beta3 -> beta4?

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

#2Tony Caduto
tony_caduto@amsoftwaredesign.com

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

#3Joshua D. Drake
jd@commandprompt.com
In reply to: Tony Caduto (#2)
Re: was a initdb required from 8.1beta3 -> beta4?

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/

#4Tony Caduto
tony_caduto@amsoftwaredesign.com
In reply to: Tony Caduto (#2)
Re: was a initdb required from 8.1beta3 -> beta4?

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

#5Tom Lane
tgl@sss.pgh.pa.us
In reply to: Tony Caduto (#1)
Re: was a initdb required from 8.1beta3 -> beta4?

Tony Caduto <tony_caduto@amsoftwaredesign.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