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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users