Bug 227970

Summary: Cannot backup akonadi when using Postgres database backend
Product: [Frameworks and Libraries] Akonadi Reporter: Tassilo Horn <tassilo>
Component: generalAssignee: Christophe Marin <christophe>
Status: RESOLVED FIXED    
Severity: normal CC: brian, dvratil, kdepim-bugs, reavertm, vkrause
Priority: NOR    
Version: 4.4   
Target Milestone: ---   
Platform: Gentoo Packages   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:

Description Tassilo Horn 2010-02-21 20:21:17 UTC 
Version:            (using KDE 4.4.0)
OS:                Linux
Installed from:    Gentoo Packages

I'm using KDE 4.4.0 with akonadi-server-1.3.1 using Postgres as database backend.  That works pretty good as far as I can tell, but I cannot make backups of my data, which makes me a bit nervous.

When I click the akonadi tray icon and say "Make backup..." I get a message that mysqldump or bzip2 are not installed.  bzip2 is installed, mysqldump not, but surely mysqldump is not the right tool for dumping postgres databases.  Here you want to use the pg_dump tool, and that is installed.

I guess that the postgres support is not completely ready right now.  If that's the case, take this report as feature request.
Comment 1 Brian DeRocher 2010-03-15 13:04:33 UTC 
I'm just getting started with KDE development, but i have a plan to address this issue.  And i'll propose a patch to the kde-pim team soon.
Comment 2 Brian DeRocher 2010-03-24 12:33:49 UTC 
The patch for backup works.  It is under review and not committed yet.  I'm starting work on restore.
Comment 3 Tassilo Horn 2010-03-24 12:36:27 UTC 
(In reply to comment #2)
> The patch for backup works.  It is under review and not committed yet.  I'm
> starting work on restore.

Brian, that's good to hear.  Thanks a lot for your effort!
Comment 4 Christophe Marin 2010-06-27 17:59:17 UTC 
Taking this one.
Comment 5 Christophe Marin 2010-06-27 18:40:27 UTC 
SVN commit 1143403 by cgiboudeaux:

Make the DB backup and restoration work for the Postgres backend.

CCBUG: 227970





 M  +38 -12    backup.cpp  
 M  +3 -0      backup.h  
 M  +38 -13    global.cpp  
 M  +6 -0      global.h  
 M  +32 -9     restore.cpp  
 M  +3 -0      restore.h  


WebSVN link: http://websvn.kde.org/?view=rev&revision=1143403
Comment 6 Daniel Vrátil 2013-03-02 22:54:19 UTC 
Closing as the issue has been apparently addresses.