Re: was a initdb required from 8.1beta3 -> beta4? - Mailing list 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/