On Thu, 19 Sep 2013 17:06:48 +0200 Mauro <mrsan...@gmail.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
