On Thu, May 12, 2005 at 02:56:35PM -0400, Tom Lane wrote: > "Reid Thompson" <[EMAIL PROTECTED]> writes: > > Is there any solution to this other than adding memory, or am I > > mis-understanding the error? > > > pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064) > > pg_dump: lost synchronization with server, resetting connection > > My bet is that this is actually a corrupt-data problem ... unless you > actually have any 875MB fields in your table. The implication is that > the length word of a variable-width field contains garbage. More than > likely, the whole tuple is garbaged, but this happens to be the first > visible symptom.
Just for curiosity sake: 875574064 base 10 = 34303330 base 16 Looks like the ASCII string "4030" Definitly corrupted tuple... -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
pgpt1FhLkUUfS.pgp
Description: PGP signature
