Re: Out of memory on pg_dump - Mailing list pgsql-general

From Tom Lane
Subject Re: Out of memory on pg_dump
Date
Msg-id 4143.1250867208@sss.pgh.pa.us
Whole thread Raw
In response to Out of memory on pg_dump  ("Chris Hopkins" <chopkins@cra.com>)
Responses Re: Out of memory on pg_dump  ("Chris Hopkins" <chopkins@cra.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: DB Design Advice
Next
From: David Waller
Date:
Subject: "Number of columns exceed limit" on a hierarchy of views