Arch Linux

t0ken

Member

Registered: 2012-06-29

Posts: 29

Akonadi and Postgresql

Not sure if I should file a bug with Arch or with upstream on this, if anyone has an idea, please let me know.

So, when I set Akonadi to use an internal postgresql backend, I'm getting the following error and the server fails to start:

[agoree@sideswipe akonadi]# cat ~/.local/share/akonadi/akonadiserver.error
Database process exited unexpectedly during initial connection! 
executable: "/usr/bin/pg_ctl" 
arguments: ("-w", "-t10", "start", "-D/home/agoree/.local/share/akonadi/db_data") 
stdout: "waiting for server to start....FATAL:  could not create lock file "/run/postgresql/.s.PGSQL.5432.lock": Permission denied
.... stopped waiting
" 
stderr: "pg_ctl: could not start server
Examine the log output.
" 
exit code: 1 
process error: "Process operation timed out"

Here is the relevant section in my akonadiserverrc:

[QPSQL]
StartServer=true
Name=akonadi
Host=
User=
Password=
Port=5432
Options=
ServerPath=/usr/bin/pg_ctl
InitDbPath=/usr/bin/initdb

If I chown /run/postgresql to my user, it'll work flawlessly -- however, after a reboot /run/postgresql will (correctly) revert back to the default perms and so it's kind of a painful workaround.  I've also tried setting "Host=/home/agoree/.local/share/akonadi/psql-socket" in the akonadiserverrc file, however I get the same error. 

Any direction on this would be much appreciated!