Message-ID: <a45642cc5574077ea57536812273bd10ae4bd1c5.camel@cybertec.at>
Subject: Re: fail to run postgresql16 after update from postgresql13
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ianseeks <bingmybong@btinternet.com>, pgsql-novice@lists.postgresql.org
Date: Thu, 02 Nov 2023 11:16:33 +0100
In-Reply-To: <4842483.GXAFRqVoOG@lian-li>
References: <4842483.GXAFRqVoOG@lian-li>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/a45642cc5574077ea57536812273bd10ae4bd1c5.camel%40cybertec.at>
Precedence: bulk

On Thu, 2023-11-02 at 08:14 +0000, Ianseeks wrote:
> i hope i've got the correct mailing list for this question/problem.  I'm =
a=20
> novice.

If you upgraded all the way from 9.6 to v16, you are not a novice.
But that's fine.  I find that - for whatever reason - people who write
to the pgsql-novice rarely are.  Perhaps modesty.

Anyway.

> A little history.=20
> I use opensuse tumbleweed and the Kmail/Kontact PIM software which is=20
> contrlled by software called Akondai and this requires a DB.  The default=
 was=20
> Mysql but it caused a lot of reliability issues for me so i migrated to=
=20
> Postgresql 9.6 (yes, it was a few years ago)
>=20
> I've since then update the DB to 10, 11, 12 until ver 13 which i=20
> have been using until now.  I  did try updating to ver 14 but it failed w=
ith=20
> locale issues during the update and i couldn't get a resolution.
>=20
> I just recently managed to get the database converted from postgresql13 t=
o=20
> postgresql16 and the data was transferred to the new DB with no issues.=
=20
>=20
> I can't get Akonadi to load as it fails to start postgresql16, its failin=
g=20
> with a message saying it needs postgesql9.6 as the DB was originally crea=
ted=20
> using 9.6. I can't see why it insists on ver 9.6 being there as i've upda=
ted=20
> to ver 16 and that process means i create an empty DB.  I can't even inst=
all=20
> Ver 9.6 to see if that cures the problem as its no longer in the opensuse=
=20
> repos.
>=20
> Here are the error messages from akonadi and the journal.
>=20
> --------------
>=20
> This is from "systemctl status postgresql.service"
>=20
> Oct 31 16:24:13 Lian-Li systemd[1]: Starting PostgreSQL database server..=
.
> Oct 31 16:24:13 Lian-Li postgresql-script[5916]:  Your database files wer=
e created by PostgreSQL version 9.6.
> Oct 31 16:24:13 Lian-Li postgresql-script[5916]:  Could not find executab=
les for this version.
> Oct 31 16:24:13 Lian-Li postgresql-script[5916]:  Please install the Post=
greSQL server package for version 9.6.
> Oct 31 16:24:13 Lian-Li systemd[1]: postgresql.service: Control process e=
xited, code=3Dexited, status=3D1/FAILURE
> Oct 31 16:24:13 Lian-Li systemd[1]: postgresql.service: Failed with resul=
t 'exit-code'.
> Oct 31 16:24:13 Lian-Li systemd[1]: Failed to start PostgreSQL database s=
erver.

These error messages are not from PostgreSQL, but they seem to be from
the script "postgresql-script".  That script is not part of PostgreSQL.

Look into that script and try to figure out how it arrives at that conclusi=
on.
If you cannot figure it out yourself, please share the relevant parts.

Yours,
Laurenz Albe