[GENERAL] pg_dump - lost synchronization with server: got message type "d", length 6036499

2008-07-01 Thread Klint Gore
Can someone shed some light on what's happening here? D:\backups>pg_dump -Z 9 -Fc -C -U postgres -f sheepcrc\dbback.dmp sheepcrc2 pg_dump: Dumping the contents of table "uploadeddatafiles" failed: PQgetCopyData () failed. pg_dump: Error message from server: lost synchronization with server: go

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

2008-07-02 Thread Tom Lane
Klint Gore <[EMAIL PROTECTED]> writes: > Can someone shed some light on what's happening here? > D:\backups>pg_dump -Z 9 -Fc -C -U postgres -f sheepcrc\dbback.dmp sheepcrc2 > pg_dump: Dumping the contents of table "uploadeddatafiles" failed: > PQgetCopyData > () failed. > pg_dump: Error message fr

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

2008-07-02 Thread Klint Gore
Tom Lane wrote: Klint Gore <[EMAIL PROTECTED]> writes: > Can someone shed some light on what's happening here? > D:\backups>pg_dump -Z 9 -Fc -C -U postgres -f sheepcrc\dbback.dmp sheepcrc2 > pg_dump: Dumping the contents of table "uploadeddatafiles" failed: > PQgetCopyData > () failed. > pg_dum

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

2008-07-02 Thread Tom Lane
Klint Gore <[EMAIL PROTECTED]> 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 ha

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

2008-07-02 Thread Klint Gore
Tom Lane wrote: Klint Gore <[EMAIL PROTECTED]> 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 > m

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

2008-07-02 Thread Tom Lane
Klint Gore <[EMAIL PROTECTED]> 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 retur

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

2008-07-02 Thread Klint Gore
Tom Lane wrote: Klint Gore <[EMAIL PROTECTED]> 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 > (

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

2008-07-02 Thread Tom Lane
Klint Gore <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Would you be willing to send me a "pg_dump -s" (ie, just schema no >> data) dump of this DB? Off-list of course. >> > attached. created with pg_dump 8.3.3 win32 to the 8.3.1 win32 server. Thanks. When I reload this here and try to pg_

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

2008-07-03 Thread Dave Page
On Thu, Jul 3, 2008 at 1:49 AM, Klint Gore <[EMAIL PROTECTED]> wrote: > I'm running it under my own account which has adminstrator rights. > Peak memory usage was about 540m which brought the total usage for the > machine to about half the physical memory allocated (3g total). > Is there a binary

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

2008-07-03 Thread Klint Gore
Tom Lane wrote: Klint Gore <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Would you be willing to send me a "pg_dump -s" (ie, just schema no >> data) dump of this DB? Off-list of course. >> > attached. created with pg_dump 8.3.3 win32 to the 8.3.1 win32 server. Thanks. When I reload this