aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/bin/pg_dump/pg_dumpall3
1 files changed, 2 insertions, 1 deletions
diff --git a/src/bin/pg_dump/pg_dumpall b/src/bin/pg_dump/pg_dumpall
index 36dbba71cc2..1fd452d1f8a 100644
--- a/src/bin/pg_dump/pg_dumpall
+++ b/src/bin/pg_dump/pg_dumpall
@@ -47,7 +47,8 @@ copy tmp_pg_shadow to stdout;
drop table tmp_pg_shadow;
END
echo "${BS}."
-psql -l -A -q -t| tr '|' ' ' | grep -v '^template1 ' | \
+psql -l -A -q -t | grep '|' | tr '|' ' ' | sed -n '2,$p' | \
+grep -v '^template1 ' | \
while read DATABASE DBUSERID ENCODING DATAPATH
do
POSTGRES_USER="`echo \" \