On Thursday, November 12, 2015 07:30:49 AM Mick wrote: > On Thursday 12 Nov 2015 04:48:49 J. Roeleveld wrote: > > On 11 November 2015 23:07:41 CET, Mick <michaelkintz...@gmail.com> wrote: > > >On Wednesday 11 Nov 2015 20:28:07 Marc Joliet wrote: > > >> On Wednesday 11 November 2015 20:37:24 J. Roeleveld wrote: > > >> >I saw plenty of errors with mysql. > > >> > > > >> >After switching to Postgresql, they seem to have disappeared. > > >> > > >> FWIW, I use mariadb myself, which is also the virtual/mysql default > > >> provider, last I checked. > > >> > > >> Greetings > > > > > >@Mark: Yes, same here, but the errors are produced by mariadb too. > > > > > >@Joost: Is postgresql starting as a process by akonadi, or are you > > >running it > > >independently and pointing akonadi to it? > > > > > >PS. I read somewhere that if mysql is running independently of akonadi, > > >then > > >the akonadi errors/corruptions are fewer, or not happen at all. > > > > As I use Postgresql also for other stuff, it's started seperately. > > > > I also found this performs better, having it run "embedded" only had a > > slightly better performance when compared to mysql (or mariadb, don't > > remember) "embedded". > > > > A framework like akonadi should, IMO, also be able to be run on a server > > with clients connecting to there to allow different machines to all use > > the same data. > > > > The current solution makes running with a shared home and logged in from > > different clients simultaneously problematic (to say the least) > > > > -- > > Joost > > Can you please explain how you have akonadi configured to use an existing db > instance? Did you have to set up an akonadi db user and passwd?
Yes. You need to create a user with password on the database where akonadi can create the tables. Here is my akonadi-config: *** % cat .config/akonadi/akonadiserverrc [%General] Driver=QPSQL [QPSQL] Name=joost-akonadi Host=localhost Options= ServerPath=/usr/bin/pg_ctl InitDbPath=/usr/bin/initdb StartServer=false User=<username> Password=<password> Port=5432 [Debug] Tracer=null *** It also works with the database running on a different machine. -- Joost
signature.asc
Description: This is a digitally signed message part.