On Thu, 19 Sep 2013 17:06:48 +0200
Mauro <mrsanna1 AT gmail DOT com> wrote:

> Hello.
> I'm using bacula in a linux debian system.
> I've to backup about 30 hosts.
> I've choose postresql as database.
> What do you think about?
> Better mysql or postgres?

Unless you will have directories with unusually high quantities of
files on those hosts (for instance, backup directories maintained by
rsnapshot, huge mail spools etc) both should perform well.

The basic idea is that each (full) filename backed up makes up one
record in one of the tables of the Bacula catalog, plus each unique
pathname makes up one record in its another table.  Consequently, when
you have *huge* number of distinct files in a backup job, this might
kneel your database.  I've personally seen despooling of attributes for
some 800k files taking more than 24 hours with a reasonably tuned (for
high-memory) MySQL instance using the MyISAM storage backend.  I'm not
sure would Postrges beat MySQL in this situation, and if yes then by
which margin.  In this particular case I've just switched to using the
bpipe plugin for backing up that particular fileset -- simply because
restoring individual files from it makes little sense anyway.

------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users