Hi list, I am using freebsd 6.1, bacula 1.38.11_1, and postgresql-server-7.4.13_1. Each night I dump 913,157,728,765 bytes of 5,395,281 files to tape. I spool data and attributes. I will need to almost triple this amount to deploy bacula. Data goes to tape in under 16.5 hours, but attributes continue going into the catalog for over 13 hours afterwards. In other words, I'm still writing the previous night's data to the database when the new day's backup cycle starts. I never get a chance to get an ascii dump of the db before the next backup cycle begins.
My untuned postgres is too slow. I'm researching ways to speed it up. If you have pointers, please share. Furthermore, each night has many errors like the following. What do these mean and how do I fix them? postgres[19278]: [324-1] ERROR: index "delinx1" does not exist postgres[19278]: [325-1] ERROR: index "delinx1" does not exist postgres[19278]: [326-1] ERROR: table "delcandidates" does not exist postgres[19278]: [327-1] ERROR: index "delinx1" does not exist postgres[19278]: [328-1] ERROR: index "delinx1" does not exist postgres[19278]: [329-1] ERROR: table "delcandidates" does not exist postgres[19278]: [330-1] ERROR: index "delinx1" does not exist postgres[19278]: [331-1] ERROR: index "delinx1" does not exist postgres[19278]: [332-1] ERROR: table "delcandidates" does not exist postgres[19278]: [333-1] ERROR: index "delinx1" does not exist postgres[19278]: [334-1] ERROR: index "delinx1" does not exist postgres[19278]: [335-1] ERROR: table "delcandidates" does not exist postgres[19278]: [336-1] ERROR: index "delinx1" does not exist postgres[19278]: [337-1] ERROR: index "delinx1" does not exist postgres[19278]: [338-1] ERROR: table "delcandidates" does not exist postgres[19278]: [339-1] ERROR: index "delinx1" does not exist postgres[19278]: [340-1] ERROR: index "delinx1" does not exist postgres[19278]: [341-1] ERROR: table "delcandidates" does not exist postgres[19278]: [342-1] ERROR: index "delinx1" does not exist postgres[19278]: [343-1] ERROR: index "delinx1" does not exist postgres[19278]: [344-1] ERROR: table "delcandidates" does not exist postgres[19278]: [345-1] ERROR: index "delinx1" does not exist postgres[19278]: [346-1] ERROR: index "delinx1" does not exist postgres[19278]: [347-1] ERROR: table "delcandidates" does not exist postgres[19278]: [348-1] ERROR: index "delinx1" does not exist postgres[19278]: [349-1] ERROR: index "delinx1" does not exist Thank you for your help. Bacula is well on its way to replacing our current method of madness. I just need to sort a few more things out. Adam ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
