Bacula-users

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

2013-01-10 08:17:23
Subject: Re: [Bacula-users] PGSQL: make_catalog_backup.pl dumps everything?
From: Martin Simmons <martin AT lispworks DOT com>
To: bacula-users AT lists.sourceforge DOT net
Date: Thu, 10 Jan 2013 13:14:44 GMT
>>>>> On Thu, 10 Jan 2013 08:53:28 +0100, Wolfgang Denk said:
> 
> 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.

Are you sure that it dumps the whole server?  The postgresql.org doc for the
dbname argument to pg_dump says that it only ever dumps one database:

"Specifies the name of the database to be dumped. If this is not specified,
the environment variable PGDATABASE is used. If that is not set, the user name
specified for the connection is used."

The make_catalog_backup.pl script sets PGDATABASE.

__Martin

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