-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 01/11/2013 04:42 PM, Wolfgang Denk wrote: > Dear Andreas, > > In message > <20130110095801.horde.olsom06jtahq7okzvfiu...@webmail.kwsoft.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 |$&| |__| | | |__/ | \| _| |novos...@umdnj.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
