John Drescher wrote: >> Hi every: >> I've been using Bacula for a while and now I have a big question: it's >> possible to save the database data? I mean like an SQL query or a dump? Any >> plugins for do that? >> > I do it the same way bacula does it for the catalog. mysql or > postgresql dump utilities. This is good if the database can be dumped > in a few minutes. For example the 27GB database for my bacula catalog > dumps in less than 10 minutes (actually the whole job finishes in that > time).
You ever tried restoring a postgres dump? I've spent some time trying to sort mine out because the restore and re-index time was 3-4 hours and the only solution to this was four times as many disks. The solution I'm using right now is an LVM snapshot of the underlying filesystem the database lives on then back that up. In theory at least (and I've asked on the Postgres IRC channel) that should be fine - though the database will have to do crash recovery when it restarts. James. -- James Cort IT Manager U4EA Technologies Ltd. -- U4EA Technologies http://www.u4eatech.com ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
