Re: pg_dump - lost synchronization with server: got message

Tom Lane wrote:
> Klint Gore <kgore4@[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_dump it, I see no
evidence
> of any problem --- pg_dump completes pretty quickly and seems to eat
> no more than a megabyte or so.  I'm not sure what to make of that.
> Could there be a Windows-specific memory problem in pg_dump?
>   
Any more thoughts on this?

The file being produced when dumping the table in question is about 1 
gig when it crashes.  In the last check-in for fe-protocol3.c, there's 
notes about 1 gig strings so I'm wondering if my data when received by 
pg_dump (or output by the 8.3.1 server) goes over?  270m of bytea 
converted to \xxx octal strings would make something > 1 gig.  But the 
270m is spread over 400 rows with nothing bigger than 3m.

If there's no interest in researching this any further, then I'll stop 
the server and take a file system copy of the data directory and upgrade 
it to 8.3.3 and pray the problem goes away.

klint.

-- 
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350

Ph: 02 6773 3789  
Fax: 02 6773 3266
EMail: kgore4@[EMAIL PROTECTED]
 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general