Re: database files are incompatible with server

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: database files are incompatible with server
Date: 2019-08-23 01:49:24
Message-ID: 5afe920c-4fce-a4dd-823c-3db521ba6362@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/22/19 6:29 PM, Ron wrote:
> On 8/22/19 7:08 PM, Adrian Klaver wrote:
>> On 8/22/19 4:52 PM, Igal @ Lucee.org wrote:
>>> I have a data directory that was created by Postgres 12 (I thought
>>> beta 3 but now am not sure anymore) running in Docker.
>>>
>>> I have installed Postgres 12b3 as a Systemd service and am trying to
>>> set the cluster to the same PGDATA.  I have set the owner of the
>>> directory to postgres:postrgres, and the permissions to 0700, but I'm
>>> getting the following error:
>>>
>>> 2019-08-22 23:40:48.759 UTC [23044] FATAL:  database files are
>>> incompatible with server
>>> 2019-08-22 23:40:48.759 UTC [23044] DETAIL:  The database cluster was
>>> initialized with CATALOG_VERSION_NO  201906161, but the server was
>>> compiled with CATALOG_VERSION_NO 201907221.
>>
>> So the cluster is from an older version then the server.
>
> Aren't Pg files supposed to be compatible within minor versions?
>

Betas are a moving target so that does not hold:

https://www.postgresql.org/developer/beta/

"Features are subject to changes that are backwards incompatible at any
time during the development of the betas, and could possibly be removed
altogether."

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-08-23 02:12:17 Re: database files are incompatible with server
Previous Message Ron 2019-08-23 01:29:37 Re: database files are incompatible with server