3 # Copyright (C) 2000-2015 Kern Sibbald
4 # License: BSD 2-Clause; see file LICENSE-FOSS
6 # shell script to delete Bacula tables for PostgreSQL
8 bindir=@POSTGRESQL_BINDIR@
11 $bindir/psql -f - -d ${db_name} $* <<END-OF-DATA
12 drop table unsavedfiles;
34 drop table locationlog;
35 drop table PathVisibility;
36 drop table PathHierarchy;
37 drop table RestoreObject;
43 echo "Deletion of Bacula PostgreSQL tables succeeded."
45 echo "Deletion of Bacula PostgreSQL tables failed."