Bacula-users

Re: [Bacula-users] PGSQL: make_catalog_backup.pl dumps everything?

2013-01-10 11:16:54
Subject: Re: [Bacula-users] PGSQL: make_catalog_backup.pl dumps everything?
From: Dan Langille <dan AT langille DOT org>
To: <bacula-users AT lists.sourceforge DOT net>
Date: Thu, 10 Jan 2013 11:14:28 -0500
On 2013-01-10 02:53, Wolfgang Denk wrote:
> Hello,
>
> I noticed that running "make_catalog_backup.pl" with a PostgreSQL
> database runs "pg_dump -c" (i. e. without specifying a database),
> which results in a full dump of the whole DB server, including far
> more than the Bacula catalog.
>
> Is this a bug, or intentional?  If the latter, what is the rationale?
>
> I'm running Bacula 5.2.12-3 on Fedora 17 systems.

I take the scripts provided by Bacula as being suggestions.  I always 
copy
them out of the base installation location, and modify them for my 
specific
needs.

Case in point: mtx-changer.

I suggest that you do similar.

FYI, this is what I do:

   RunBeforeJob = "/home/bacula/make_catalog_backup.new MyCatalog"
   RunBeforeJob = "/usr/bin/tar -czf /wdc/bacula/MyCatalog.tgz 
/wdc/bacula/MyCatalog.sql"

Where /home/bacula/make_catalog_backup.new is a Python script, I think 
provided by Unbuntu,
which searches the bacula-dir.conf file for the Catalog entry called 
MyCatalog.  It uses
that information to connect to the database server and dumps that 
single database.

HTH.

-- 
Dan Langille - http://langille.org/

------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users