Re: [GENERAL] pg_dump on older version of postgres eating huge

2004-03-19 Thread Steve Krall
I've done this with the debug level all the way up... You can get the file here( 20 megs uncompressed, 130K compressed ): http://www.papajohns.com/postgres/postgres.log.bz2 While this dump was running, top reported that pg_dump was taking up around 500-550megs. Then the machine stopped

Re: [GENERAL] pg_dump on older version of postgres eating huge

2004-03-19 Thread Steve Krall
We do have quite a few trigger. Some are RI triggers postgres automagically creates. The remaining triggers are used for things like audit tables, or logging who updated a row etc... I did what you suggested. I ran pg_dump dbname file.dmp. Immediatly aftwards, kill -ABRT pid. I ended up