Re: pg_dump on older version of postgres eating huge amounts of memory - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump on older version of postgres eating huge amounts of memory
Date
Msg-id 16636.1079663889@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump on older version of postgres eating huge amounts of memory  (Steve Krall <swalker@iglou.com>)
Responses Re: pg_dump on older version of postgres eating huge
List pgsql-general
Steve Krall <swalker@iglou.com> writes:
> When doing a pg_dump databasename > file.dmp pg_dump eats up all the
> memory, and is eventually killed because it takes
> up a huge amount of memory.  The dump file is always 0 bytes.  It works
> perfectly fine on our other server.

> When we run pg_dump in verbose mode, it is trying to get the trigger
> information.

Can you run it with query logging turned on, so we can see what query(s)
it's issuing while it eats RAM?

            regards, tom lane

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: pg_dump on older version of postgres eating huge amounts of memory
Next
From: Francisco Reyes
Date:
Subject: Post to hacker list