From 4bdc1a801b89307f5b63e2f86edfad36ad5d7b06 Mon Sep 17 00:00:00 2001
From: Carlo Landmeter <clandmeter@alpinelinux.org>
Date: Sat, 3 Feb 2018 21:15:57 +0000
Subject: add pgsql dump profile

---
 profiles/backup-pgsql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100755 profiles/backup-pgsql

diff --git a/profiles/backup-pgsql b/profiles/backup-pgsql
new file mode 100755
index 0000000..89fa6a3
--- /dev/null
+++ b/profiles/backup-pgsql
@@ -0,0 +1,13 @@
+#!/bin/sh
+
+# To dump pgsql databases make sure to export the following variables.
+# This can be done from /etc/lbu/rbu.conf or add it to this file.
+# PGUSER, PGPASSWORD, PGHOST, PGDATABASE
+# Set GZIP to pigz for multi core compression (if installed)
+
+if [ -n "$PGPASSWORD" ]; then
+	echo "Dumping PostgreSQL database to: $BACKUP_CACHE"
+	pg_dump | ${GZIP:-gzip} > "$BACKUP_CACHE"/dump.sql.gz
+else
+	echo "PostgreSQL password not set, skipping pg_dump."
+fi
-- 
cgit v1.2.3