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: | 7c1574a90911031032o51a6f0e2v2646a2487e8de2c6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
LlamaLand https://netllama.linux-sxs.org
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Wood | 2009-11-03 18:38:24 | Re: corrupt db |
Previous Message | Lars Gustafsson | 2009-11-03 18:30:32 | Re: corrupt db |