pgsql: Add a --role option to pg_dump, pg_dumpall, and pg_restore.

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add a --role option to pg_dump, pg_dumpall, and pg_restore.
Date: 2009-01-05 16:54:37
Message-ID: 20090105165437.38D74754A17@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Add a --role option to pg_dump, pg_dumpall, and pg_restore. This allows
performing dumps and restores in accordance with a security policy that
forbids logging in directly as superuser, but instead specifies that you
should log into an admin account and then SET ROLE to the superuser.

In passing, clean up some ugly and mostly-broken code for quoting shell
arguments in pg_dumpall.

Benedek Lszl, with some help from Tom Lane

Modified Files:
--------------
pgsql/doc/src/sgml/ref:
pg_dump.sgml (r1.105 -> r1.106)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/pg_dump.sgml?r1=1.105&r2=1.106)
pg_dumpall.sgml (r1.73 -> r1.74)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/pg_dumpall.sgml?r1=1.73&r2=1.74)
pg_restore.sgml (r1.76 -> r1.77)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/pg_restore.sgml?r1=1.76&r2=1.77)
pgsql/src/bin/pg_dump:
pg_backup.h (r1.47 -> r1.48)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_backup.h?r1=1.47&r2=1.48)
pg_backup_archiver.c (r1.159 -> r1.160)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_backup_archiver.c?r1=1.159&r2=1.160)
pg_dump.c (r1.511 -> r1.512)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c?r1=1.511&r2=1.512)
pg_dumpall.c (r1.110 -> r1.111)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dumpall.c?r1=1.110&r2=1.111)
pg_restore.c (r1.89 -> r1.90)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_restore.c?r1=1.89&r2=1.90)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2009-01-05 17:14:28 pgsql: Change the reloptions machinery to use a table-based parser, and
Previous Message User Gleu 2009-01-05 16:29:26 pgsnap - pgsnap: Forgot the php keyword in <? line and the copyright on