Modify pg_dumpall so that output script uses new OWNER option of CREATE
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 24 Feb 2002 21:57:23 +0000 (21:57 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 24 Feb 2002 21:57:23 +0000 (21:57 +0000)
commit8bb49c1390281b863d24d8452510338a533a85bd
treeaec45e765280e34f1d0bfa844f178e9c66e432d3
parentcec538e9652a1177b1d3a3efc6d171c07f0c6d6c
Modify pg_dumpall so that output script uses new OWNER option of CREATE
DATABASE; also make it use SET SESSION AUTHORIZATION commands rather than
\connect commands.  This makes it possible to restore databases belonging
to users who do not have CREATEDB privilege.  It should also become at
least somewhat feasible to run the restore script under password
authentication --- you'll get one superuser password prompt per database,
rather than a large number of challenges for passwords belonging to
varying unspecified user names.
src/bin/pg_dump/pg_dumpall.sh