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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Guillaume Drolet <droletguillaume(at)gmail(dot)com>
Cc: 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 14:44:02
Message-ID: 53513A32.3090002@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 04/18/2014 06:25 AM, Guillaume Drolet wrote:
> Thanks for the doc on pg_resetxlog. Will try it next week when I'm
> back from Easter holiday, first backuping $PGDATA.
>
> Most of my databases are stored in a default tablespace I defined on a
> different disk than that of my PG installation (and $PGDATA): could I
> just reinstall PG and then re-link it with my databases on that disk?
>

Not really, $PGDATA holds the global information for the cluster. If you
reinstalled which implies another initdb then you would have a
head($PGDATA) that knows nothing about the rest of the body.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Spence 2014-04-18 14:49:08 Re: Arduino SQL Connector
Previous Message Adrian Klaver 2014-04-18 14:35:33 Re: Arduino SQL Connector