Re: Dump

Mihai Gheorghiu <tanhq@bigplanet.com> writes:
>>> I wanted to back up a database prior to upgrading to 7.0.2
>>> pg_dump dbname > dbname.bak
>>> FATAL 1: Memory exhausted in AllocSetAlloc()
>>> PQendcopy: resetting connection
>>> SQL query to dump the contents of Table 'tblname' did not execute
>>> correctly.
>>
>> Hmm, what version are you using now?  COPY used to have a memory leak
>> problem according to the CVS logs, but that was long ago (pre-6.4).

> 7.0 on RH6.1

OK, so much for the old-version theory.  What is the full declaration of
table 'tblname'?  (Easiest way to get it is pg_dump -s -t tblname dbname.)
Also, how many rows in the table?

            regards, tom lane