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/