Re: Cluster recovery - FATAL: database files are incompatible with server. Different PG_CONTROL_VERSION for cluster and server.

From: Guillaume Drolet <droletguillaume(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Cluster recovery - FATAL: database files are incompatible with server. Different PG_CONTROL_VERSION for cluster and server.
Date: 2014-04-18 13:33:32
Message-ID: CAOkiyv4FCaPU-y8zqipvG53EpgDeutzDY78gdXZJRtL+hvZAhg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

No the new test cluster isn't running anymore: I deleted it right
after I deleted my main one.

Re the error messages: I was calling pg_ctl with the option -D
<path_to_my_main_cluster_datadir>

2014-04-18 8:44 GMT-04:00 droletguillaume <droletguillaume(at)gmail(dot)com>:
>
>
>
> Sent from Samsung Mobile
>
>
> -------- Original message --------
> From: Adrian Klaver
> Date:04-17-2014 20:36 (GMT-05:00)
> To: Guillaume Drolet ,pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Cluster recovery - FATAL: database files are
> incompatible with server. Different PG_CONTROL_VERSION for cluster and
> server.
>
> On 04/17/2014 01:29 PM, Guillaume Drolet wrote:
>> Dear list users,
>>
>> For some tests, I installed a new cluster with different parameters
>> than the ones I had used a while ago to create the cluster I use for
>> my day-to-day activities (let's call it my main cluster). I used
>> initdb --no-locale -E UTF8 -D <new_data_dir>. Then I used pg_ctl -D
>> <new_data_dir> to start my new cluster. So far so good.
>>
>> Then, I realized that I wanted to add a database superuser with the
>> option -U to initdb so I decided to delete the newly created cluster.
>> Instead, I mistakenly deleted the data directory of my main cluster
>> (doh!), using Shift-Delete. I recovered the deleted data directory
>> using Panda Recovery Tool and copied it back into its location (the
>> location pointed to by $PGDATA).
>>
>> Now for the real problems: if I go in pgAdmin and try to connect to my
>> cluster, I get the "server not listening" message. I also tried going
>> to the Services and restarting postgresql but it says it is already
>> stopped and if I try to start it, I get a message that it has started
>> but then stopped because it was unused.
>>
>> If I try pg_ctl start, I get this message (my translation from
>> French): FATAL: database files are incompatible with server. DETAIL:
>> Database cluster was initialized with a PG_CONTROL_VERSION ? 16795209
>> while the server was compiled with a PG_CONTROL_VERSION ? 937. HINT:
>> Looks like you need initdb.
>
>
> More thoughts.
>
> What happened to the new cluster?
>
> Is it still running?
>
> When you got the error messages where you pointing at the old or new
> cluster?
>
>>
>> I really don't know what to do and would appreciate any help, if
>> anything can be done to recover my databases. My PG version is 9.3.3
>> on a Windows 7 64-bit OS.
>>
>> Best regards and many thanks for your advice,
>>
>> Guillaume
>>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com

Browse pgsql-general by date

  From Date Subject
Next Message Ron Pasch 2014-04-18 13:59:55 Could use some advice on search architecture
Previous Message Guillaume Drolet 2014-04-18 13:25:34 Re: Cluster recovery - FATAL: database files are incompatible with server. Different PG_CONTROL_VERSION for cluster and server.