Thread: pgsql/src/bin/pg_dump pg_dumpall.sh

pgsql/src/bin/pg_dump pg_dumpall.sh

From
tgl@postgresql.org (Tom Lane)
Date:
CVSROOT:    /cvsroot
Module name:    pgsql
Changes by:    tgl@postgresql.org    02/02/24 16:57:23

Modified files:
    src/bin/pg_dump: pg_dumpall.sh

Log message:
    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.