From: | "Igal (at) Lucee(dot)org" <igal(at)lucee(dot)org> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: database files are incompatible with server |
Date: | 2019-08-23 03:42:00 |
Message-ID: | 46b394f7-0c7d-e338-b0f2-2d732b3dd17d@lucee.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 8/22/2019 5: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.
>
>>
>> How can I start up the Cluster?
>>
>> Is version 201906161 beta 2?
>
> Yes:
>
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/include/catalog/catversion.h;h=fe44cae3ff453ccc02e6c56548c9311b5777bf1f;hb=0ab7110bcbcce5ff58afb32e7871c54e87502139
>
>>
>> Would running PG12 beta 2 work?
>
> Worth a try.
That worked. I used the Docker image postgres:12-beta2 to bring up the
server.
One issue that I kept having was error messages like chown: changing
ownership of '...': Permission denied. That turned out to be an SELinux
issue on the CentOS machine. I have set SELinux to permissive mode
temporarily to bring the server up. Sharing it here for the next guy
(most likely my future self).
Thanks again,
Igal
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-08-23 04:15:19 | Re: database files are incompatible with server |
Previous Message | Adrian Klaver | 2019-08-23 02:36:17 | Re: database files are incompatible with server |