On Tue, Aug 30, 2011 at 10:00 PM, Strauch, Sheldon <sstra...@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. What I 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 be avoided. 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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
