On Tue, Aug 30, 2011 at 10:00 PM, Strauch, Sheldon
<SStrauch@enovafinancial.com> wrote:
>
> Well, the file was 1.3M lines long, including an entire dump from over a year ago. I did not examine the entire file.
WhatI saw looked reasonably well-formed. I suspect the size of the file is the actual culprit.
Ouch, yes, that does sound pretty huge. We do now have options to let
you choose the number of history entries that are stored and the
maximum size of a stored query (with defaults of 10 and 1KB
respectively), so that shouldn't happen in the future.
> It was a bit disturbing to see "ALTER ROLE xxxx WITH PASSWORD 'yyyyyy';" in clear-text. However, I suppose that can't
beavoided.
Not easily, at least without the chance of getting things wrong. I'm
not sure that's a real worry though - we could potentially just
exclude any query that contains ALTER/CREATE ROLE ... WITH PASSWORD
> Once again, thank you so much for your help,
You're welcome.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company