On 15 November 2015 17:32:07 CET, Mick <michaelkintz...@gmail.com> wrote: >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.
To migrate calendar data, I would export to an ical file and then reimport it. For contacts, use vcf. Both of these are mostly human readable and allow for simple editing if necessary. I am not certain this will work. I would suggest testing with a temporary user first. -- Joost -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
