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)
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 |