Use the command line utility dropdb instead of the psql command

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

diff --git a/bacula/src/cats/update_bacula_tables.in b/bacula/src/cats/update_bacula_tables.in
index a1b1984cac5209ac503872ca74302161733fbf10..40b9a89a2e85350aa883fab85a474108971a3f55 100755 (executable)
--- a/bacula/src/cats/update_bacula_tables.in
+++ b/bacula/src/cats/update_bacula_tables.in
@@ -1,13 +1,18 @@
 #!/bin/sh
 #
 # This routine alters the appropriately configured
-#  Bacula tables for either MySQL or SQLite
+#  Bacula tables for PostgreSQL, MySQL, or SQLite.
 #
 if test xsqlite = x@DB_NAME@ ; then
   echo "Altering SQLite tables"
-  . ./update_sqlite_tables
+  @scriptdir@/update_sqlite_tables
 fi
 if test xmysql = x@DB_NAME@ ; then
   echo "Altering MySQL tables"
-  . ./update_mysql_tables
+  @scriptdir@/update_mysql_tables $*
+fi
+if test xpostgresql = x@DB_NAME@ ; then
+  echo "Altering PostgreSQL tables"
+  # we need the bacula datbase name in here... Should not be hardcoded
+  @scriptdir@/update_postgresql_tables bacula
 fi