On Thursday 12 Nov 2015 08:05:52 J. Roeleveld wrote: > 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
Thank you Joost. Did you export/import akonadi databases when you moved over from MySQL, or was it not necessary? One of the databases contains calendar data and I do not want to cause loss of it. -- Regards, Mick
signature.asc
Description: This is a digitally signed message part.
