[Kde-pim] Experiences with PostgreSQL backend (was: Re: ... MySQL backend: tuning for larger accounts...)

[Cédric Villemain]

Le jeudi 27 mars 2014 12:10:25 Daniel Vrátil a écrit :
> On Thursday 27 of March 2014 11:27:58 Martin Steigerwald wrote:
> > Am Donnerstag, 27. März 2014, 10:54:16 schrieb Daniel Vrátil:
> > > On Wednesday 26 of March 2014 16:58:35 GEO wrote:
> > > > On Wednesday 26 March 2014 15:04:27 Daniel Vrátil wrote:
> > > > > MariaDB is a drop-in replacement for MySQL, so it's supported
> > > > > by
> > > > > default
> > > > > (I've  been using MariaDB instead of MySQL for over year
> > > > > before I
> > > > > switched
> > > > > to PSQL)
> > > > 
> > > > Just interested: You use the akonadi postgresql backend as your
> > > > default one?
> > > 
> > > Yes, and I'm a happy man now :-)
> > 
> > Why? What did it improve?
> 
> I was having problems with data corruption when using MariaDB. No idea
> why.
> > I used it once, but still before the pre-mail times of Akonadi, as
> > KMail was not using it yet. Both with Akonadi started and central
> > PostgreSQL.
> Lot has changed since then :-)
> 
> > I wondered about the support in Akonadi and I wondered about
> > upgrades
> > between major PostgreSQL versions
> 
> We now have a PostgreSQL developer on our side (klando), who has
> improved the way we detect, start and stop PostgreSQL server in
> Akonadi in 1.12 a lot.  I don't know about upgrades between PSQL
> version, but I dare to assume they work just fine :-)

Major version upgrade is 1/ rare (major version of PostgreSQL are 
supported 'stable' for 5 years) 2/ handled by dump/restore or pg_upgrade 
binary tool for larger databases.

Some distribution packages can propose an upgrade script. Really not 
something to worry for a desktop, IMHO.

-- 
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20140327/39893092/attachment.sig>
-------------- next part --------------
_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/