Re: corrupt db

From: Lonni J Friedman <netllama(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:24:39
Message-ID: 7c1574a90911031024u5515fad4na3f04717601c7efe@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

How did you get the data onto the new server?

On Tue, Nov 3, 2009 at 10:00 AM, Lars Gustafsson <gumse(at)mac(dot)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(at)gmail(dot)com
LlamaLand https://netllama.linux-sxs.org

In response to

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Wood 2009-11-03 18:29:08 Re: [NOVICE] Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list
Previous Message Kris Jurka 2009-11-03 18:16:15 Re: Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list