Skip site navigation (1) Skip section navigation (2)

pgsql: Allow pg_dumpall to dump roles w/o user passwords

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow pg_dumpall to dump roles w/o user passwords
Date: 2017-03-07 14:06:44
Message-ID: E1clFlE-0004j2-5S@gemulon.postgresql.org (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-committers
Allow pg_dumpall to dump roles w/o user passwords

Add new option --no-role-passwords which dumps roles without passwords.
Since we don’t need passwords, we choose to use pg_roles in preference
to pg_authid since access may be restricted for security reasons in
some configrations.

Robins Tharakan and Simon Riggs

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/9a83d56b38c870ce47b7651385ff2add583bf136

Modified Files
--------------
doc/src/sgml/ref/pg_dumpall.sgml |  13 ++++
src/bin/pg_dump/pg_dumpall.c     | 132 +++++++++++++++++++++++++--------------
2 files changed, 97 insertions(+), 48 deletions(-)


pgsql-committers by date

Next:From: Peter EisentrautDate: 2017-03-07 14:07:52
Subject: Re: pgsql: Support SCRAM-SHA-256 authentication (RFC 5802 and 7677).
Previous:From: Heikki LinnakangasDate: 2017-03-07 13:25:15
Subject: Re: pgsql: Support SCRAM-SHA-256 authentication (RFC 5802 and 7677).

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group