]> granicus.if.org Git - postgresql/commit
Add a --role option to pg_dump, pg_dumpall, and pg_restore. This allows
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 5 Jan 2009 16:54:37 +0000 (16:54 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 5 Jan 2009 16:54:37 +0000 (16:54 +0000)
commitb0a6ad70a12b6949fdebffa8ca1650162bf0254a
tree5f54962ab205dc20a48f8398bc39403f193b93ab
parentf42a7f1e62d8fa8dc6a1e5cc351cd6ffa4ec1b22
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 László, with some help from Tom Lane
doc/src/sgml/ref/pg_dump.sgml
doc/src/sgml/ref/pg_dumpall.sgml
doc/src/sgml/ref/pg_restore.sgml
src/bin/pg_dump/pg_backup.h
src/bin/pg_dump/pg_backup_archiver.c
src/bin/pg_dump/pg_dump.c
src/bin/pg_dump/pg_dumpall.c
src/bin/pg_dump/pg_restore.c