Re: Broken after upgrade

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(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.

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(dot)klaver(at)aklaver(dot)com