remove GROUP BY on db_get_job_volume_names. REVIEW.

[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 fe9c774fc3b9b311e4bf21d5837fcf488ba8fd93..f2327dee593b8a8acae50ea45179843cbc401f0c 100755 (executable)
--- a/bacula/src/cats/make_catalog_backup.in
+++ b/bacula/src/cats/make_catalog_backup.in
@@ -8,7 +8,11 @@ rm -f bacula.sql
 if test xsqlite = x@DB_NAME@ ; then
   echo ".dump" | @SQL_BINDIR@/sqlite bacula.db >bacula.sql
 else
-  @SQL_BINDIR@/mysqldump $* -f --opt bacula >bacula.sql
+  if test xmysql = x@DB_NAME@ ; then
+    @SQL_BINDIR@/mysqldump $* -f --opt bacula >bacula.sql
+  else
+    @SQL_BINDIR@/pg_dump $* bacula >bacula.sql
+  fi
 fi
 #
 #  To read back a MySQL database use: 
@@ -21,3 +25,8 @@ fi
 #     rm -f bacula.db
 #     sqlite bacula.db <bacula.sql
 #
+#  To read back a PostgreSQL database use:
+#     cd @working_dir@
+#     dropdb bacula
+#     psql bacula <bacula.sql
+#