diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2001-01-25 17:28:15 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2001-01-25 17:28:15 +0000 |
| commit | 7e44f8f9e5c8156bacd9e7c75f73dc4655fd3742 (patch) | |
| tree | 62f2edf9737b3dd1c05f3f237b465046225e2eb1 /src | |
| parent | e01e14ed66613bbf055621722e2557b82fdc0971 (diff) | |
| download | postgresql-7e44f8f9e5c8156bacd9e7c75f73dc4655fd3742.tar.gz postgresql-7e44f8f9e5c8156bacd9e7c75f73dc4655fd3742.zip | |
For missing owner of database, default to superuser.
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/pg_dump/pg_dumpall.sh | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/bin/pg_dump/pg_dumpall.sh b/src/bin/pg_dump/pg_dumpall.sh index 6eae7e2df24..a3b80fe251d 100644 --- a/src/bin/pg_dump/pg_dumpall.sh +++ b/src/bin/pg_dump/pg_dumpall.sh @@ -6,7 +6,7 @@ # and "pg_group" tables, which belong to the whole installation rather # than any one individual database. # -# $Header: /cvsroot/pgsql/src/bin/pg_dump/Attic/pg_dumpall.sh,v 1.9 2000/12/19 22:12:47 petere Exp $ +# $Header: /cvsroot/pgsql/src/bin/pg_dump/Attic/pg_dumpall.sh,v 1.10 2001/01/25 17:28:15 petere Exp $ CMDNAME=`basename $0` @@ -192,7 +192,7 @@ test "$globals_only" = yes && exit 0 # connect to them anyway (and besides, we don't want to dump template0). $PSQL -d template1 -At -F ' ' \ - -c "SELECT datname, usename, pg_encoding_to_char(d.encoding), datistemplate, datpath FROM pg_database d LEFT JOIN pg_shadow u ON (datdba = usesysid) WHERE datallowconn;" | \ + -c "SELECT datname, coalesce(usename, (select usename from pg_shadow where usesysid=(select datdba from pg_database where datname='template0'))), pg_encoding_to_char(d.encoding), datistemplate, datpath FROM pg_database d LEFT JOIN pg_shadow u ON (datdba = usesysid) WHERE datallowconn;" | \ while read DATABASE DBOWNER ENCODING ISTEMPLATE DBPATH; do echo echo "--" |