From 57ae3c18b72ee9add23c024fccee320054b5f6b5 Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
Date: Tue, 31 Dec 2024 15:32:29 +0000
Subject: Use function for postgresql backup

---
 scripts/backup.cron | 15 +++++++++------
 1 file changed, 9 insertions(+), 6 deletions(-)

(limited to 'scripts/backup.cron')

diff --git a/scripts/backup.cron b/scripts/backup.cron
index 71c97e8..2490c54 100755
--- a/scripts/backup.cron
+++ b/scripts/backup.cron
@@ -60,12 +60,15 @@ rm -f ${basedir}/${prefix}.0/ldap.ldif.xz
 ldapsearch | xz > ${basedir}/${prefix}.0/ldap.ldif.xz
 
 echo "Begin PostgreSQL @ `date`" >> ${basedir}/time
-rm -f ${basedir}/${prefix}.0/postgresql-gentoobrowse.sql.xz
-pg_dump -Upostgres gentoobrowse | xz > ${basedir}/${prefix}.0/postgresql-gentoobrowse.sql.xz
-rm -f ${basedir}/${prefix}.0/postgresql-p2pvr.sql.xz
-pg_dump -Upostgres p2pvr | xz > ${basedir}/${prefix}.0/postgresql-p2pvr.sql.xz
-rm -f ${basedir}/${prefix}.0/postgresql-bugzilla.sql.xz
-pg_dump -Upostgres bugzilla | xz > ${basedir}/${prefix}.0/postgresql-bugzilla.sql.xz
+function pq() {
+	rm -f ${basedir}/${prefix}.0/postgresql-$1.sql.xz
+	pg_dump -Upostgres $1 | xz > ${basedir}/${prefix}.0/postgresql-$1.sql.xz
+}
+pq bugzilla
+pq gentoobrowse
+pq mirrorsearch
+pq p2pvr
+pq sa_bayes
 
 echo "Begin hardlink @ `date`" >> ${basedir}/time
 do_nsca "Backup Volume" /usr/lib64/nagios/plugins/check_disk -w 5% -c 2% $basedir
-- 
cgit v1.2.3