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

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:32:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
That's never a recommended way to move data.  You need to take the
dump and import it into the new instance.

On Tue, Nov 3, 2009 at 10:30 AM, Lars Gustafsson <gumse(at)mac(dot)com> wrote:
> 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(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

In response to

pgsql-novice by date

Next:From: Michael WoodDate: 2009-11-03 18:38:24
Subject: Re: corrupt db
Previous:From: Lars GustafssonDate: 2009-11-03 18:30:32
Subject: Re: corrupt db

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