public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: Ianseeks <[email protected]>
To: [email protected]
Subject: Re: fail to run postgresql16 after update from postgresql13
Date: Thu, 02 Nov 2023 11:16:33 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <4842483.GXAFRqVoOG@lian-li>
References: <4842483.GXAFRqVoOG@lian-li>
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
> 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.
> I use opensuse tumbleweed and the Kmail/Kontact PIM software which is
> contrlled by software called Akondai and this requires a DB. The default was
> Mysql but it caused a lot of reliability issues for me so i migrated to
> Postgresql 9.6 (yes, it was a few years ago)
>
> I've since then update the DB to 10, 11, 12 until ver 13 which i
> have been using until now. I did try updating to ver 14 but it failed with
> locale issues during the update and i couldn't get a resolution.
>
> I just recently managed to get the database converted from postgresql13 to
> postgresql16 and the data was transferred to the new DB with no issues.
>
> I can't get Akonadi to load as it fails to start postgresql16, its failing
> with a message saying it needs postgesql9.6 as the DB was originally created
> using 9.6. I can't see why it insists on ver 9.6 being there as i've updated
> to ver 16 and that process means i create an empty DB. I can't even install
> Ver 9.6 to see if that cures the problem as its no longer in the opensuse
> repos.
>
> Here are the error messages from akonadi and the journal.
>
> --------------
>
> This is from "systemctl status postgresql.service"
>
> 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 were created by PostgreSQL version 9.6.
> Oct 31 16:24:13 Lian-Li postgresql-script[5916]: Could not find executables for this version.
> Oct 31 16:24:13 Lian-Li postgresql-script[5916]: Please install the PostgreSQL server package for version 9.6.
> Oct 31 16:24:13 Lian-Li systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE
> Oct 31 16:24:13 Lian-Li systemd[1]: postgresql.service: Failed with result 'exit-code'.
> Oct 31 16:24:13 Lian-Li systemd[1]: Failed to start PostgreSQL database server.
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 conclusion.
If you cannot figure it out yourself, please share the relevant parts.
Yours,
Laurenz Albe
view thread (5+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: fail to run postgresql16 after update from postgresql13
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox