Re: Dumping roles improvements? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Dumping roles improvements?
Date
Msg-id 3164.1318364375@sss.pgh.pa.us
Whole thread Raw
In response to Re: Dumping roles improvements?  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Dumping roles improvements?  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> On 10/11/2011 12:40 PM, Bruce Momjian wrote:
>> Josh Berkus wrote:
>>> pg_dumpall -r --no-passwords which would dump the roles but without
>>> CREATE PASSWORD statements.  This would be useful for cloning databases
>>> for use in Dev, Test and Staging, where you don't what to copy the md5s
>>> of passwords for possible cracking.

>> What would this do that pg_dumpall --globals-only doesn't?

> As stated, it would not export the passwords.

I can see some possible use in a --no-passwords option that's orthogonal
to all else.  The rest of this seems rather confused...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: SET variable - Permission issues
Next
From: Simon Riggs
Date:
Subject: Re: Overhead cost of Serializable Snapshot Isolation