Search Postgresql Archives

Re: was a initdb required from 8.1beta3 -> beta4?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux