Re: Out of memory on pg_dump

"Chris Hopkins" <chopkins@cra.com> writes:
> 2009-08-19 22:35:42 ERROR:  out of memory
> 2009-08-19 22:35:42 DETAIL:  Failed on request of size 536870912.

> Is there an easy way to give pg_dump more memory?

That isn't pg_dump that's out of memory --- it's a backend-side message.
Unless you've got extremely wide fields in this table, I would bet on
this really being a corrupted-data situation --- that is, there's some
datum in the table whose length word has been corrupted into a very
large value.  You can try to isolate and delete the corrupted row(s).

            regards, tom lane