From 793bcd21ce8ee923aeb9f37a02ac856cc89b51c3 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Sun, 17 Mar 2019 18:49:52 +0000
Subject: [PATCH] etc/profile.d/pg.sh

---
 etc/profile.d/pg.sh | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/etc/profile.d/pg.sh b/etc/profile.d/pg.sh
index 1fb5aa51..86c0c85f 100644
--- a/etc/profile.d/pg.sh
+++ b/etc/profile.d/pg.sh
@@ -46,7 +46,7 @@ pg_backups_dir() {
 (
   dir=${1:?Usage: pg_dumpall_var_backups DIR}
   cd /
-  psql -d template1 -c 'select 1' >/dev/null 2>&1 || return 0
+  su postgres -c 'psql -d template1 -c "select 1" >/dev/null 2>&1' || return 0
   [ -d "$dir" ] || mkdir -p "$dir"
   su postgres -c 'pg_dumpall -c -o' | bzip2 -9 -c > "$dir"/pg_dumpall.sql.bz2
   su postgres -c 'vacuumdb -q -a -z'
-- 
2.47.3