Re: Dump

Mihai Gheorghiu <tanhq(at)bigplanet(dot)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