From 2fc04874a61b9d62555d2118cb15e48bc448d0e1 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 14 May 1997 19:49:34 +0000 Subject: [PATCH] Allow pg_dumpall to preserve database ownership. --- src/bin/pg_dump/pg_dumpall | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/src/bin/pg_dump/pg_dumpall b/src/bin/pg_dump/pg_dumpall index ff10a2a0da..2cf83c3be1 100644 --- a/src/bin/pg_dump/pg_dumpall +++ b/src/bin/pg_dump/pg_dumpall @@ -5,18 +5,19 @@ # It also dumps the pg_user table # # to adapt to System V vs. BSD 'echo' -set -x +#set -x if echo '\\' | grep '\\\\' >/dev/null 2>&1 then BS='\' # BSD else BS='\\' # System V fi -psql -l -A -q -t|cut -d"|" -f1 | grep -v '^template1$' | \ -while read DATABASE +psql -l -A -q -t|cut -d"|" -f1-2 | tr '|' ' ' | grep -v '^template1 ' | \ +while read DATABASE USER do echo "${BS}connect template1" echo "create database $DATABASE;" + echo "update pg_database set datdba = $USER where datname = '$DATABASE';" echo "${BS}connect $DATABASE" pg_dump "$@" $DATABASE done -- 2.11.0