Re: corrupt db - Mailing list pgsql-novice

From Lars Gustafsson
Subject Re: corrupt db
Date
Msg-id 2A0D2C87-B716-4898-85DD-CE23E180DEEC@mac.com
Whole thread Raw
In response to Re: corrupt db  (Lonni J Friedman <netllama@gmail.com>)
Responses Re: corrupt db  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-novice
He had the /data directory on a USB memory

Lars.


3 nov 2009 kl. 19.24 skrev Lonni J Friedman:

> How did you get the data onto the new server?
>
> On Tue, Nov 3, 2009 at 10:00 AM, Lars Gustafsson <gumse@mac.com>
> wrote:
>> 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 ?
>>
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> L. Friedman                                    netllama@gmail.com
> LlamaLand                       https://netllama.linux-sxs.org


pgsql-novice by date:

Previous
From: Michael Wood
Date:
Subject: Re: Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list
Next
From: Lonni J Friedman
Date:
Subject: Re: corrupt db