]> granicus.if.org Git - postgresql/commit
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)
commit36d2cc1d574d54f06c9f3fa53328332e6183473c
treeb3f12cca7acc5f74312be29a1090d9b4ed0b63c5
parenta833c441fd3cb92bb9cb169a6e73df8f1c6ffe95
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