Re: Broken after upgrade

Поиск
Список
Период
Сортировка
От Devrim Gündüz
Тема Re: Broken after upgrade
Дата
Msg-id 772BC2B4-FFB6-437D-A399-37C2C90BB3FC@gunduz.org
обсуждение исходный текст
Ответ на Broken after upgrade  (arnaud gaboury <arnaud.gaboury@gmail.com>)
Ответы Re: Broken after upgrade  (José María Terry Jiménez <jtj@tssystems.net>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Broken after upgrade
Следующее
От: José María Terry Jiménez
Дата:
Сообщение: Re: Broken after upgrade