"Vishal Dixit" <vishal_d@xxxxxxxxxx> 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
