Bacula-users

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

2013-01-11 16:54:39
Subject: Re: [Bacula-users] PGSQL: make_catalog_backup.pl dumps everything?
From: "Novosielski, Ryan" <novosirj AT umdnj DOT edu>
To: Wolfgang Denk <wd AT denx DOT de>
Date: Fri, 11 Jan 2013 16:52:01 -0500
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/11/2013 04:42 PM, Wolfgang Denk wrote:
> Dear Andreas,
> 
> In message
> <20130110095801.Horde.OlSoM06jTahQ7oKZVfIUClA AT webmail.kwsoft DOT de>
> you wrote:
>> 
>>> 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 would say that this is intentional for people just want to use
>>  Bacula and therfore need a database. If you use the Bacula
>> database in a non standard way eg. for more that just Bacula, you
>> should also be able to roll out your own backup strategie for the
>> DB.
> 
> I think you minsunderstand.
> 
> I am not using the bacula DB in any nonstandard way or for other 
> purposes.
> 
> The problem I see / the question I have is that the script 
> "make_catalog_backup.pl" as distributed with bacula will not only
> dump the bacula database, but _all_ databases on the whole
> PostgreSQL _server_.
> 
> If I use one machine as a DB server, I might use it to hold other 
> databases (completely unrelated to bacula) as well.  I've been
> using MySQL so far, and here "make_catalog_backup.pl" will dump
> only the bacula DB (i. e. MyCatalog).  When using a PostgreSQL
> server, the script will not dump only this one DB, but all other,
> completely unrelated databases as well (plus the DB schema and what
> else).
> 
> I think this is not correct - I may end up backing up many, many 
> gigabytes of data which are totally unrelated.

Furthermore, the MySQL counterpart of this script does NOT do this. In
fact, it only backs up the bacula database (which I just recently
realized I have to modify to back up my alternate catalog).

- -- 
- ---- _  _ _  _ ___  _  _  _
|Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Sr. Systems Programmer
|$&| |__| |  | |__/ | \| _| |novosirj AT umdnj DOT edu - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent.|IST/EI-Academic Svcs. - ADMC 450, Newark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with undefined - http://www.enigmail.net/

iEYEARECAAYFAlDwiXgACgkQmb+gadEcsb748wCgip2HrHkTu499GdxhjzvbotEw
AgYAoNwflFrCli+AEJoiiUk/cnE0s0wY
=8oFk
-----END PGP SIGNATURE-----


------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users