patch 5db77239908259b2142c6ea88150f179a6e572d2
Author: "Karl O. Pinc" <kop@meme.com>
Date: Wed Aug 15 20:51:45 EDT 2018
* bin/gombemi_postgres_backup_cron: Dump meta-information about the databases
hunk ./bin/gombemi_postgres_backup_cron 137
+# Backup the meta-information about the databases.
+secure_file $PGB_DATA_DIR/metadata.txt
+accessdb "psql -U $PG_ADMIN --echo-queries" > $PGB_DATA_DIR/metadata.txt <<EOF
+select pg_database.*
+ , pg_authid.rolname as owner
+ , pg_tablespace.spcname
+ from pg_database
+ join pg_authid
+ on (pg_authid.oid = pg_database.datdba)
+ join pg_tablespace
+ on (pg_tablespace.oid = pg_database.dattablespace)
+ order by pg_database.datname;
+
+select pg_tablespace.* pg_authid, rolname as owner
+ from pg_tablespace
+ join pg_authid on (pg_authid.oid = pg_tablespace.spcowner)
+ order by pg_tablespace.spcname;
+EOF
+if [ "$?" != "0" ] ; then
+ syslog crit 'CRITICAL Failed to backup metadata.txt (db metadata).'
+else
+ syslog debug 'Backed up roles.sql (users and groups).'
+fi
+