Add delta option to db_get_file_list()

[bacula/bacula] / bacula / src / cats / make_catalog_backup.in

diff --git a/bacula/src/cats/make_catalog_backup.in b/bacula/src/cats/make_catalog_backup.in
index 1a5d2370b85ff8dcedaaa868f62e8521b69bcbd5..b27ffb77d94fe78baff684b0b24a953295638ad9 100755 (executable)
--- a/bacula/src/cats/make_catalog_backup.in
+++ b/bacula/src/cats/make_catalog_backup.in
@@ -8,30 +8,47 @@
 #  $2 is the user name with which to access the database
 #     (default = bacula).
 #  $3 is the password with which to access the database or "" if no password
+#     (default ""). WARNING!!! Passing the password via the command line is 
+#     insecure and should not be used since any user can display the command 
+#     line arguments and the environment using ps.  Please consult your
+#     MySQL or PostgreSQL manual for secure methods of specifying the
+#     password.
+#  $4 is the host on which the database is located
 #     (default "")
 #
 #
 BINDIR=@SQL_BINDIR@
 
 cd @working_dir@
-rm -f bacula.sql
-if test xsqlite = x@DB_NAME@ ; then
+rm -f $1.sql
+if test xsqlite = x@DB_TYPE@ ; then
   echo ".dump" | ${BINDIR}/sqlite $1.db >$1.sql
 else
-  if test xmysql = x@DB_NAME@ ; then
+  if test xmysql = x@DB_TYPE@ ; then
     if test $# -gt 2; then
       MYSQLPASSWORD=" --password=$3"
     else
       MYSQLPASSWORD=""
     fi
-    ${BINDIR}/mysqldump -u $2$MYSQLPASSWORD -f --opt $1 >$1.sql
+    if test $# -gt 3; then
+      MYSQLHOST=" --host=$4"
+    else
+      MYSQLHOST=""
+    fi
+    ${BINDIR}/mysqldump -u ${2}${MYSQLPASSWORD}${MYSQLHOST} -f --opt $1 >$1.sql
   else                       
-    if test xpostgresql = x@DB_NAME@ ; then
+    if test xpostgresql = x@DB_TYPE@ ; then
       if test $# -gt 2; then
        PGPASSWORD=$3
        export PGPASSWORD
       fi
-      exec ${BINDIR}/pg_dump -c -U $2 $1 >$1.sql
+      if test $# -gt 3; then
+       PGHOST=" --host=$4"
+      else
+       PGHOST=""
+      fi
+      # you could also add --compress for compression.  See man pg_dump
+      exec ${BINDIR}/pg_dump -c $PGHOST -U $2 $1 >$1.sql
     else
       echo ".dump" | ${BINDIR}/sqlite3 $1.db >$1.sql
     fi
@@ -51,6 +68,6 @@ fi
 #  To read back a PostgreSQL database use:
 #     cd @working_dir@
 #     dropdb bacula
-#     createdb bacula
+#     createdb bacula -T template0 -E SQL_ASCII
 #     psql bacula <bacula.sql
 #