Re: database files are incompatible with server

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.

>
> Would running initdb destroy the data?

initdb will not run on a directory with files in it:

bin/initdb -D /usr/local/pgsql11_dev/
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

initdb: directory "/usr/local/pgsql11_dev" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/usr/local/pgsql11_dev" or run initdb
with an argument other than "/usr/local/pgsql11_dev".

>
> Thank you,
>
> Igal Sapir
> Lucee Core Developer
> Lucee.org <http://lucee.org/>
>

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