Modify pg_dumpall so that output script uses new OWNER option of CREATE

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 36d2cc1d574d54f06c9f3fa53328332e6183473c
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2002-02-24T21:57:23Z
Releases: 7.3.1
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.

Files

PathChange+/−
src/bin/pg_dump/pg_dumpall.sh modified +31 −20