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 19488.1215046946@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 it's
>> dying here after having leaked a lot of memory for some other reason
>> --- try watching the pg_dump process size while it runs.

> Peak memory usage was about 540m which brought the total usage for the
> machine to about half the physical memory allocated (3g total).

Well, that might well explain the failure.  pg_dump does suck a lot of
schema information into memory at startup, but 540m seems excessive.
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?

            regards, tom lane

pgsql-general by date:

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