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 02:36:17 |
Message-ID: | eb736885-7f85-645c-d290-606de15949ca@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 8/22/19 7:12 PM, Ron wrote:
> On 8/22/19 8:49 PM, Adrian Klaver wrote:
>> 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."
>
> Features as in the on-disk structure?
>
Short version:
T
he error was about the catversion which tracks the system catalog state.
Adding/subtracting features can change that state and make clusters
incompatible.
Long version:
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Igal @ Lucee.org | 2019-08-23 03:42:00 | Re: database files are incompatible with server |
Previous Message | Igal @ Lucee.org | 2019-08-23 02:31:22 | Re: database files are incompatible with server |