3 # shell script to delete Bacula tables for PostgreSQL
5 # Bacula® - The Network Backup Solution
7 # Copyright (C) 2000-2014 Free Software Foundation Europe e.V.
9 # The main author of Bacula is Kern Sibbald, with contributions from many
10 # others, a complete list can be found in the file AUTHORS.
12 # You may use this file and others of this release according to the
13 # license defined in the LICENSE file, which includes the Affero General
14 # Public License, v3.0 ("AGPLv3") and some additional permissions and
15 # terms pursuant to its AGPLv3 Section 7.
17 # Bacula® is a registered trademark of Kern Sibbald.
20 bindir=@POSTGRESQL_BINDIR@
23 $bindir/psql -f - -d ${db_name} $* <<END-OF-DATA
24 drop table unsavedfiles;
46 drop table locationlog;
47 drop table PathVisibility;
48 drop table PathHierarchy;
49 drop table RestoreObject;
54 echo "Deletion of Bacula PostgreSQL tables succeeded."
56 echo "Deletion of Bacula PostgreSQL tables failed."