Use PostgreSQL in Akonadi

·
1 min read
notes
#kde #ubuntu #akonadi

How to enable akonadi with PostgreSQL as backend.

Stop Akonadi server first:

Terminal window
akonadictl stop

Install:

Terminal window
sudo apt install postgresql-12 akonadi-backend-postgresql

Change postgresql-12 with postgresql or whichever exists on your distro. I’m using latest KDE Neon.

Create a configuration file $HOME/.config/akonadi/akonadiserverrc The content:

[%General]
Driver=QPSQL


[QPSQL]
Host=/tmp/akonadi-user.RqiEZ0
InitDbPath=/usr/lib/postgresql/12/bin/initdb
Name=akonadi
Options=
ServerPath=/usr/lib/postgresql/12/bin/pg_ctl
StartServer=true

Change InitDbPath and ServerPath if you use different PostgreSQL.

Start Akonadi and check its integrity.

Terminal window
akonadictl stop
akonadictl fsck

Source: https://prkos.hr/KOrganizer-and-Akonadi-Ubuntu-with-Postgres

Related Articles

Intel IPU6 Camera on Kubuntu 24.04 in Dell Latitude 7340

Intel IPU6 Camera on Kubuntu 24.04 in Dell Latitude 7340

Install Kubuntu 24.04 in Dell Latitude 7340

Install Kubuntu 24.04 in Dell Latitude 7340

[WIP] How to Install OpenVINO GenAI on Ubuntu 25.04 with oneMKL and jemalloc for Agentic Coding

[WIP] How to Install OpenVINO GenAI on Ubuntu 25.04 with oneMKL and jemalloc for Agentic Coding