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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Klint Gore <kgore4(at)une(dot)edu(dot)au>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump - lost synchronization with server: got message type "d", length 6036499
Date: 2008-07-03 04:02:32
Message-ID: 22791.1215057752@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Klint Gore <kgore4(at)une(dot)edu(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Klint Gore 2008-07-03 04:37:18 Re: pg_dump - lost synchronization with server: got message type "d", length 6036499
Previous Message Tom Lane 2008-07-03 03:55:54 Re: Memory use in 8.3 plpgsql with heavy use of xpath()