Skip site navigation (1) Skip section navigation (2)

Re: corrupt db

From: Michael Wood <esiotrot(at)gmail(dot)com>
To: Lars Gustafsson <gumse(at)mac(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: corrupt db
Date: 2009-11-03 18:38:24
Message-ID: 5a8aa6680911031038h4cbd4883pad3adcab5b5b7a02@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
2009/11/3 Lars Gustafsson <gumse(at)mac(dot)com>:
> A client of mine hade a HD crash, he had a backup of his pgsql/data catalog,
> but when trying to start the server (on a newly installed postgres, same
> version he had) I get the following message:
>
> postgres$ FATAL:  database files are incompatible with server
> DETAIL:  The database cluster was initialized with PG_CONTROL_VERSION
> 906166272, but the server was compiled with PG_CONTROL_VERSION 822.
> HINT:  It looks like you need to initdb.
>
>
> Is it beyond repair ? Any last resorts ?

This might not be it, but make sure you're using a 32 bit version of
Postgres if the old server was 32 bits, and a 64 bit version if the
old server was 64 bit.

-- 
Michael Wood <esiotrot(at)gmail(dot)com>

In response to

  • corrupt db at 2009-11-03 18:00:32 from Lars Gustafsson

Responses

pgsql-novice by date

Next:From: Richard BroersmaDate: 2009-11-03 18:39:54
Subject: Re: [NOVICE] Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list
Previous:From: Lonni J FriedmanDate: 2009-11-03 18:32:37
Subject: Re: corrupt db

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group