Re: Dumping roles improvements?

On 10/11/2011 04:19 PM, Tom Lane wrote:
> 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...
>
>             

Yes, I also think that will meet the case.

cheers

andrew