Обсуждение: pg_dump throws no buffer space available error

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.

Thanks.

________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag

"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