From d5e7a2c1d123b7161297959648db950ece353d26 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Sun, 26 Oct 2025 16:54:11 +0100
Subject: [PATCH] etc/profile.d/pg.sh

---
 etc/profile.d/pg.sh | 40 +++++++++++++++-------------------------
 1 file changed, 15 insertions(+), 25 deletions(-)

diff --git a/etc/profile.d/pg.sh b/etc/profile.d/pg.sh
index e641b96f..47f82908 100644
--- a/etc/profile.d/pg.sh
+++ b/etc/profile.d/pg.sh
@@ -38,31 +38,21 @@ 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"
 }
 
-# NB 17.03.19: TODEL 
-# NB 17.03.19 pg_dumpall_var_backups() {
-# NB 17.03.19 (
-# NB 17.03.19   cd /
-# NB 17.03.19   psql -d template1 -c 'select 1' >/dev/null 2>&1
-# NB 17.03.19   su postgres -c 'pg_dumpall -c -o' | bzip2 -9 -c > /var/backups/pg_dumpall.sql.bz2
-# NB 17.03.19   su postgres -c 'vacuumdb -q -a -z'
-# NB 17.03.19   )
-# NB 17.03.19 }
-
-pg_backups_dir() {
-(
-  dir=${1:?Usage: pg_dumpall_var_backups DIR}
-  cd /
-  su postgres -c 'psql -d template1 -c "select 1" >/dev/null 2>&1' || return 0
-  [ -d "$dir" ] || mkdir -p "$dir"
-  if pg_dumpall --help |grep '\--oids' -q
-  then
-  	su postgres -c 'pg_dumpall -c --oids' | bzip2 -9 -c > "$dir"/pg_dumpall.sql.bz2
-  else
-  	su postgres -c 'pg_dumpall -c' | bzip2 -9 -c > "$dir"/pg_dumpall.sql.bz2
-  fi
-  su postgres -c 'vacuumdb -q -a -z'
-)
-}
+# NB 26.10.25 pg_backups_dir() {
+# NB 26.10.25 (
+  # NB 26.10.25 dir=${1:?Usage: pg_dumpall_var_backups DIR}
+  # NB 26.10.25 cd /
+  # NB 26.10.25 su postgres -c 'psql -d template1 -c "select 1" >/dev/null 2>&1' || return 0
+  # NB 26.10.25 [ -d "$dir" ] || mkdir -p "$dir"
+  # NB 26.10.25 if pg_dumpall --help |grep '\--oids' -q
+  # NB 26.10.25 then
+  	# NB 26.10.25 su postgres -c 'pg_dumpall -c --oids' | bzip2 -9 -c > "$dir"/pg_dumpall.sql.bz2
+  # NB 26.10.25 else
+  	# NB 26.10.25 su postgres -c 'pg_dumpall -c' | bzip2 -9 -c > "$dir"/pg_dumpall.sql.bz2
+  # NB 26.10.25 fi
+  # NB 26.10.25 su postgres -c 'vacuumdb -q -a -z'
+# NB 26.10.25 )
+# NB 26.10.25 }
 
 pg_backup() {
 	local keep_days=7
-- 
2.47.3