13 files changed, 39 insertions, 13 deletions

diff --git a/databases/postgresql-devel-server/files/502.pgsql b/databases/postgresql-devel-server/files/502.pgsql
index 3a44f1132ac8..c372163f7407 100644
--- a/databases/postgresql-devel-server/files/502.pgsql
+++ b/databases/postgresql-devel-server/files/502.pgsql
@@ -53,10 +53,12 @@ echo "PostgreSQL maintenance"
 umask 077
 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
 rc=$?
+file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"`
+pg_dumpall -g | gzip -9 > ${file}.gz
 for db in ${dbnames}; do
     echo -n " $db"
     file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
-    pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
+    pg_dump ${PGDUMP_ARGS} -f ${file} ${db}
     [ $? -gt 0 ] && rc=3
 done
 
diff --git a/databases/postgresql7/files/502.pgsql b/databases/postgresql7/files/502.pgsql
index 3a44f1132ac8..c372163f7407 100644
--- a/databases/postgresql7/files/502.pgsql
+++ b/databases/postgresql7/files/502.pgsql
@@ -53,10 +53,12 @@ echo "PostgreSQL maintenance"
 umask 077
 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
 rc=$?
+file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"`
+pg_dumpall -g | gzip -9 > ${file}.gz
 for db in ${dbnames}; do
     echo -n " $db"
     file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
-    pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
+    pg_dump ${PGDUMP_ARGS} -f ${file} ${db}
     [ $? -gt 0 ] && rc=3
 done
 
diff --git a/databases/postgresql73-server/files/502.pgsql b/databases/postgresql73-server/files/502.pgsql
index 3a44f1132ac8..c372163f7407 100644
--- a/databases/postgresql73-server/files/502.pgsql
+++ b/databases/postgresql73-server/files/502.pgsql
@@ -53,10 +53,12 @@ echo "PostgreSQL maintenance"
 umask 077
 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
 rc=$?
+file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"`
+pg_dumpall -g | gzip -9 > ${file}.gz
 for db in ${dbnames}; do
     echo -n " $db"
     file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
-    pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
+    pg_dump ${PGDUMP_ARGS} -f ${file} ${db}
     [ $? -gt 0 ] && rc=3
 done
 
diff --git a/databases/postgresql73/files/502.pgsql b/databases/postgresql73/files/502.pgsql
index 3a44f1132ac8..c372163f7407 100644
--- a/databases/postgresql73/files/502.pgsql
+++ b/databases/postgresql73/files/502.pgsql
@@ -53,10 +53,12 @@ echo "PostgreSQL maintenance"
 umask 077
 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
 rc=$?
+file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"`
+pg_dumpall -g | gzip -9 > ${file}.gz
 for db in ${dbnames}; do
     echo -n " $db"
     file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
-    pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
+    pg_dump ${PGDUMP_ARGS} -f ${file} ${db}
     [ $? -gt 0 ] && rc=3
 done
 
diff --git a/databases/postgresql74-server/files/502.pgsql b/databases/postgresql74-server/files/502.pgsql
index 3a44f1132ac8..c372163f7407 100644
--- a/databases/postgresql74-server/files/502.pgsql
+++ b/databases/postgresql74-server/files/502.pgsql
@@ -53,10 +53,12 @@ echo "PostgreSQL maintenance"
 umask 077
 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
 rc=$?
+file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"`
+pg_dumpall -g | gzip -9 > ${file}.gz
 for db in ${dbnames}; do
     echo -n " $db"
     file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
-    pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
+    pg_dump ${PGDUMP_ARGS} -f ${file} ${db}
     [ $? -gt 0 ] && rc=3
 done
 
diff --git a/databases/postgresql80-server/files/502.pgsql b/databases/postgresql80-server/files/502.pgsql
index 3a44f1132ac8..c372163f7407 100644
--- a/databases/postgresql80-server/files/502.pgsql
+++ b/databases/postgresql80-server/files/502.pgsql
@@ -53,10 +53,12 @@ echo "PostgreSQL maintenance"
 umask 077
 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
 rc=$?
+file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"`
+pg_dumpall -g | gzip -9 > ${file}.gz
 for db in ${dbnames}; do
     echo -n " $db"
     file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
-    pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
+    pg_dump ${PGDUMP_ARGS} -f ${file} ${db}
     [ $? -gt 0 ] && rc=3
 done
 
diff --git a/databases/postgresql81-server/files/502.pgsql b/databases/postgresql81-server/files/502.pgsql
index 3a44f1132ac8..c372163f7407 100644
--- a/databases/postgresql81-server/files/502.pgsql
+++ b/databases/postgresql81-server/files/502.pgsql
@@ -53,10 +53,12 @@ echo "PostgreSQL maintenance"
 umask 077
 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
 rc=$?
+file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"`
+pg_dumpall -g | gzip -9 > ${file}.gz
 for db in ${dbnames}; do
     echo -n " $db"
     file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
-    pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
+    pg_dump ${PGDUMP_ARGS} -f ${file} ${db}
     [ $? -gt 0 ] && rc=3
 done
 
diff --git a/databases/postgresql82-server/files/502.pgsql b/databases/postgresql82-server/files/502.pgsql
index 3a44f1132ac8..c372163f7407 100644
--- a/databases/postgresql82-server/files/502.pgsql
+++ b/databases/postgresql82-server/files/502.pgsql
@@ -53,10 +53,12 @@ echo "PostgreSQL maintenance"
 umask 077
 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
 rc=$?
+file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"`
+pg_dumpall -g | gzip -9 > ${file}.gz
 for db in ${dbnames}; do
     echo -n " $db"
     file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
-    pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
+    pg_dump ${PGDUMP_ARGS} -f ${file} ${db}
     [ $? -gt 0 ] && rc=3
 done
 
diff --git a/databases/postgresql83-server/files/502.pgsql b/databases/postgresql83-server/files/502.pgsql
index 3a44f1132ac8..c372163f7407 100644
--- a/databases/postgresql83-server/files/502.pgsql
+++ b/databases/postgresql83-server/files/502.pgsql
@@ -53,10 +53,12 @@ echo "PostgreSQL maintenance"
 umask 077
 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
 rc=$?
+file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"`
+pg_dumpall -g | gzip -9 > ${file}.gz
 for db in ${dbnames}; do
     echo -n " $db"
     file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
-    pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
+    pg_dump ${PGDUMP_ARGS} -f ${file} ${db}
     [ $? -gt 0 ] && rc=3
 done
 
diff --git a/databases/postgresql84-server/files/502.pgsql b/databases/postgresql84-server/files/502.pgsql
index 3a44f1132ac8..c372163f7407 100644
--- a/databases/postgresql84-server/files/502.pgsql
+++ b/databases/postgresql84-server/files/502.pgsql
@@ -53,10 +53,12 @@ echo "PostgreSQL maintenance"
 umask 077
 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
 rc=$?
+file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"`
+pg_dumpall -g | gzip -9 > ${file}.gz
 for db in ${dbnames}; do
     echo -n " $db"
     file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
-    pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
+    pg_dump ${PGDUMP_ARGS} -f ${file} ${db}
     [ $? -gt 0 ] && rc=3
 done
 
diff --git a/databases/postgresql90-server/files/502.pgsql b/databases/postgresql90-server/files/502.pgsql
index 3a44f1132ac8..c372163f7407 100644
--- a/databases/postgresql90-server/files/502.pgsql
+++ b/databases/postgresql90-server/files/502.pgsql
@@ -53,10 +53,12 @@ echo "PostgreSQL maintenance"
 umask 077
 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
 rc=$?
+file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"`
+pg_dumpall -g | gzip -9 > ${file}.gz
 for db in ${dbnames}; do
     echo -n " $db"
     file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
-    pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
+    pg_dump ${PGDUMP_ARGS} -f ${file} ${db}
     [ $? -gt 0 ] && rc=3
 done
 
diff --git a/databases/postgresql91-server/files/502.pgsql b/databases/postgresql91-server/files/502.pgsql
index 3a44f1132ac8..c372163f7407 100644
--- a/databases/postgresql91-server/files/502.pgsql
+++ b/databases/postgresql91-server/files/502.pgsql
@@ -53,10 +53,12 @@ echo "PostgreSQL maintenance"
 umask 077
 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
 rc=$?
+file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"`
+pg_dumpall -g | gzip -9 > ${file}.gz
 for db in ${dbnames}; do
     echo -n " $db"
     file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
-    pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
+    pg_dump ${PGDUMP_ARGS} -f ${file} ${db}
     [ $? -gt 0 ] && rc=3
 done
 
diff --git a/databases/postgresql92-server/files/502.pgsql b/databases/postgresql92-server/files/502.pgsql
index 3a44f1132ac8..c372163f7407 100644
--- a/databases/postgresql92-server/files/502.pgsql
+++ b/databases/postgresql92-server/files/502.pgsql
@@ -53,10 +53,12 @@ echo "PostgreSQL maintenance"
 umask 077
 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
 rc=$?
+file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"`
+pg_dumpall -g | gzip -9 > ${file}.gz
 for db in ${dbnames}; do
     echo -n " $db"
     file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
-    pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
+    pg_dump ${PGDUMP_ARGS} -f ${file} ${db}
     [ $? -gt 0 ] && rc=3
 done