Re: Broken after upgrade - Mailing list pgsql-general

From Devrim Gündüz
Subject Re: Broken after upgrade
Date
Msg-id 772BC2B4-FFB6-437D-A399-37C2C90BB3FC@gunduz.org
Whole thread Raw
In response to Broken after upgrade  (arnaud gaboury <arnaud.gaboury@gmail.com>)
Responses Re: Broken after upgrade  (José María Terry Jiménez <jtj@tssystems.net>)
List pgsql-general
Hi,

Fedora packages have an executable (not sure about its name, but check a package called postgresql-upgrade or so). That will help you to finish the upgrade process.

Regards, Devrim

On July 6, 2016 9:13:50 PM GMT+03:00, arnaud gaboury <arnaud.gaboury@gmail.com> 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.

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Broken after upgrade
Next
From: José María Terry Jiménez
Date:
Subject: Re: Broken after upgrade