On Tuesday, December 29, 2015 04:34:33 PM Mick wrote: > On Tuesday 29 Dec 2015 14:18:20 J. Roeleveld wrote: > > sqlite is nice, for single threaded applications. > > For anything more advanced, either a wrapper is required or something more > > advanced needs to be used. > > I like sqlite because it is self-contained, embedded in the application that > uses it and accesses the data directly with functional calls, rather than > looping around port/socket interfaces to speak to a server. This is why I > kept it, since with Kmail1 it is not used much.
SQLite never was reliable with akonadi. That might be why so many people had all those issues. > With Kmail2 the database will be hammered so as you say will need something > that can process things in parallel at speed and in higher volumes. So, I'm > planning to install postgresql for this purpose, since in my experience > mysql has had a number of hickups with akonadi. My experience as well, which is why I switched to Postgresql. > Can you please advise what GRANTS did you use to create a dedicated > postgresql user for akonadi? Grants? I did the following: % createuser -P <akonadiuser> (NOTE: You need to set a password, which is why I use the "-P" option) % createdb -E UTF8 -O <akonadiuser> <akonadidb> My config for this is: % cat .config/akonadi/akonadiserverrc [%General] Driver=QPSQL [QPSQL] Name=<akonadidb> Host=localhost Options= ServerPath=/usr/bin/pg_ctl InitDbPath=/usr/bin/initdb StartServer=false User=<akonadiuser> Password=<akonadipassword> Port=5432 [Debug] Tracer=null > Will the same user be used for Baloo indexing, or is this an additional > database role? Afaik, no. Baloo uses it's own database engine. For the USE-flags: app-office/akonadi-server postgresql qt4 (all other USE-flags disabled) -- Joost
signature.asc
Description: This is a digitally signed message part.