"Vishal Dixit" <vishal_d@ureach.com> 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