On 07/06/2016 11:13 AM, arnaud gaboury wrote:
I am left today, after an upgrade I think (Fedora 23 --> 24) with a
broken postgresql.
It used to work very well. The service is started with the systemd
unit file. I have now this error:
-----------------
postgres@thetradinghall ➤➤ systemd/system %
/usr/libexec/postgresql-ctl start -D /db/pgsql/data -s -w -t 270
FATAL: 22023: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 9.4,
which is not compatible with this version 9.5.3.
-----------------------
Googling it gave me some entries, but I couldn't find any clear
explanation and how to solve. It seems I need to initiate a new
database, but thereafter is not clear (how to use my old data and conf
files pg_hba and pg_ident).
Thank you for hints/links how to solve this issue.
First, if possible copy your data dir and conf files somewhere for safety.
From the looks of it Fedora upgraded your Postgres from 9.4.x to 9.5.3.
That constitutes a major upgrade and as the error says the data
directory is no longer compatible.
What Postgres versions are installed?
Or did Fedora get rid of the Postgres 9.4 entirely?
I do not use Fedora so I cannot get any more specific but this might
help( I would still backup up your data directory manually, even if the
instructions below say that is done for you):
https://fedoraproject.org/wiki/PostgreSQL
in particular:
https://fedoraproject.org/wiki/PostgreSQL#Upgrade
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
