Re: pg_dump - lost synchronization with server: got message type "d", length 6036499 - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump - lost synchronization with server: got message type "d", length 6036499
Date
Msg-id 22791.1215057752@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump - lost synchronization with server: got message type "d", length 6036499  (Klint Gore <kgore4@une.edu.au>)
Responses Re: pg_dump - lost synchronization with server: got message type "d", length 6036499
List pgsql-general
Klint Gore <kgore4@une.edu.au> writes:
> Tom Lane wrote:
>> Maybe you've found a memory leak in pg_dump (it wouldn't be the first
>> one).  Does this database have a particularly large number of objects?

> I wouldn't call it large - 27 tables, 111 functions,  21 custom types
> (used for set returning function results).

[ squint... ]  Hard to see how that could be eating half a gig of
pg_dump memory space.

Would you be willing to send me a "pg_dump -s" (ie, just schema no
data) dump of this DB?  Off-list of course.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Memory use in 8.3 plpgsql with heavy use of xpath()
Next
From: Klint Gore
Date:
Subject: Re: pg_dump - lost synchronization with server: got message type "d", length 6036499