Bacula-users

Re: [Bacula-users] Bacula and databases ...

2009-02-05 08:12:15
Subject: Re: [Bacula-users] Bacula and databases ...
From: John Drescher <drescherjm AT gmail DOT com>
To: James Cort <james.cort AT u4eatech DOT com>, bacula-users <Bacula-users AT lists.sourceforge DOT net>
Date: Thu, 5 Feb 2009 08:10:09 -0500
On Thu, Feb 5, 2009 at 3:55 AM, James Cort <james.cort AT u4eatech DOT com> 
wrote:
> 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.
>
Yes I have done that with my bacula catalog (it is postgres) but I do
not remember how long this took. I did that 1 to  2 years ago.

John

------------------------------------------------------------------------------
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

<Prev in Thread] Current Thread [Next in Thread>