Re: Broken after upgrade

From: Devrim Gündüz <devrim(at)gunduz(dot)org>
To: arnaud gaboury <arnaud(dot)gaboury(at)gmail(dot)com>,pgsql-general(at)postgresql(dot)org
Subject: Re: Broken after upgrade
Date: 2016-07-06 22:14:28
Message-ID: 772BC2B4-FFB6-437D-A399-37C2C90BB3FC@gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)gaboury(at)gmail(dot)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(at)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.
>--
>
>google.com/+arnaudgabourygabx
>
>
>--
>Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message José María Terry Jiménez 2016-07-06 23:00:55 Re: Broken after upgrade
Previous Message Adrian Klaver 2016-07-06 21:49:29 Re: Broken after upgrade