From 42527353b1b451d4ec53f9ca6e9a1ee8cddb7945 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Wed, 6 Mar 2019 23:59:51 +0000
Subject: [PATCH] etc/profile.d/pg.sh

---
 etc/profile.d/pg.sh | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/etc/profile.d/pg.sh b/etc/profile.d/pg.sh
index 1b90de06..3f139359 100644
--- a/etc/profile.d/pg.sh
+++ b/etc/profile.d/pg.sh
@@ -31,3 +31,12 @@ pg_count() {
 pg_users() {
   psql template1 -c "SELECT r.rolname, r.rolsuper, r.rolinherit, r.rolcreaterole, r.rolcreatedb, r.rolcanlogin, r.rolconnlimit, r.rolvaliduntil, ARRAY(SELECT b.rolname FROM pg_catalog.pg_auth_members m JOIN pg_catalog.pg_roles b ON (m.roleid = b.oid) WHERE m.member = r.oid) as memberof , r.rolreplication FROM pg_catalog.pg_roles r ORDER BY 1"
 }
+
+pg_dumpall_var_backups() {
+(
+  cd /
+  psql -d template1 -c 'select 1' >/dev/null 2>&1
+  su postgres -c 'pg_dumpall -c -o' | bzip2 -9 -c > /var/backups/pg_dumpall.sql.bz2
+  su postgres -c 'vacuumdb -q -a -z'
+  )
+}
-- 
2.47.3