[Akonadi] [Bug 476617] postgresql16 fails to run after DB update from postgresql13 - errors from akonadictl start

[Christophe Marin]

https://bugs.kde.org/show_bug.cgi?id=476617

Christophe Marin <christophe at krop.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|general                     |server

--- Comment #1 from Christophe Marin <christophe at krop.fr> ---
(In reply to BingMyBong from comment #0)

> ---------- Errors from the journal using "journalctl -xeu postgresql.service"
> 
> Oct 31 16:24:13 Lian-Li systemd[1]: Starting PostgreSQL database server...
> Subject: A start job for unit postgresql.service has begun execution
> Defined-By: systemd
> Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
> 
> A start job for unit postgresql.service has begun execution.
>  
> The job identifier is 2241.
> 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
> Subject: Unit process exited
> Defined-By: systemd
> Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
> 
> An ExecStart= process belonging to unit postgresql.service has exited.
>  
> The process' exit code is 'exited' and its exit status is 1.
> Oct 31 16:24:13 Lian-Li systemd[1]: postgresql.service: Failed with result 
> 'exit-code'.
> Subject: Unit failed
> Defined-By: systemd
> Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel

There's a small misunderstanding here. Akonadi doesn't use the system postgres
but runs its own instance.
That's why the db lives in $HOME/.local/share/akonadi/db_data. Whatever lives
in var/lib/pgsql is not your akonadi DB.

> QSqlDatabase: QPSQL driver not loaded

This looks more interesting. Is libQt5Sql5-postgresql installed on your system?

-- 
You are receiving this mail because:
You are the assignee for the bug.