"Vishal Dixit" <[EMAIL PROTECTED]> wrote > > We are running postgres version 8.0 on windows server 2003. On > doing a pg_dump of a large database the following error occurs: > > pg_dump: could not receive data from server: No buffer space > available > > There is one table in the database containing bytea type column, > this error comes as we add more entries to this column. Please > share your thoughts. >
It is a socket error WSAENOBUFS. According to Microsoft: "No buffer space available. -- An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full." I just googled a little bit, tweak some regedit values can alleviate it, but not sure. /* For pg-hackers: http://support.microsoft.com/kb/q201213/ Anyone reports a similar thing in Unix? */ Regards, Qingqing ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
