Search Postgresql Archives

Re: database files are incompatible with server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/include/catalog/catversion.h;h=fe44cae3ff453ccc02e6c56548c9311b5777bf1f;hb=0ab7110bcbcce5ff58afb32e7871c54e87502139



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux