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.klaver@xxxxxxxxxxx
