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
