Re: database files are incompatible with server - Mailing list pgsql-general

From Igal @ Lucee.org
Subject Re: database files are incompatible with server
Date
Msg-id 266cb84e-a4a6-01e6-27c0-6fca5986d0a7@lucee.org
Whole thread Raw
In response to Re: database files are incompatible with server  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Adrian,

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

>

Thanks for the link.  It's good to know where these things are stored.

Thank you,

Igal




pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: database files are incompatible with server
Next
From: Adrian Klaver
Date:
Subject: Re: database files are incompatible with server