| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Dumping roles improvements? |
| Date: | 2011-10-11 20:29:18 |
| Message-ID: | 4E94A71E.3000900@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 10/11/2011 04:19 PM, Tom Lane wrote:
> Andrew Dunstan<andrew(at)dunslane(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2011-10-11 20:29:19 | Re: Overhead cost of Serializable Snapshot Isolation |
| Previous Message | Bruce Momjian | 2011-10-11 20:28:59 | Re: unite recovery.conf and postgresql.conf |