No buffer space available 10055

[webness]

Hola a todos, despues de ejecutar la instruccion

psql DbName <ruta_archivo.sql -U postgres

me saca un error NO BUFFER SPACE AVAILABLE.

destaco que previamente ejecute un fichero sql con aprox 600mil inserts, este otro que intentto ejecutar tiene 100mil inserts.

Estuve bucando en internet y todo lo que encontre tiene que ver con linux y problemas de salidas a Internet.

En mi caso tengo windows y estoy en el servidor local de postgres.

Gracias por su ayuda.

[huesos52]

mira esto que me encontré

No buffer space available Fix

Editting the registry is not for beginners, if you don't know what you're doing I suggest you don't try this, basically it's use at your own risk.

Anytime you want to edit the registry it is a good idea to back it up first. For information on how to backup and restore the registry in all versions of Windows click here.

If you are using Windows 95/98/Me follow these steps:

First step is to launch the registry editor. To do this go to Start, Run and type regedit. In the left pane navigate to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Servic es\VxD\MSTCP once there, look for an entry called MaxConnections. If it exists highlight it by clicking it and then right click it and select modify. Increase the value (recommended value is to double the current value).

If the MaxConnections entry does not exist you must create it. To do this, right click in the right pane and choose new from the menu and select String Value. Give it the name MaxConnections. Then right click it and select modify and enter a value of 200.

Restart your computer, if all goes well then you fixed the problem, if not, revert the changes by restoring the registry. (You may have to reboot to safe mode to do this).

If you are running Windows NT/2000/XP follow these steps: First step is to launch the registry editor. To do this go to Start, Run and type regedit. In the left pane navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Parameters once there, you must create the entry TcpNumConnections. To do this, right click in the right pane and choose new from the menu and select DWORD Value. Give it the name TcpNumConnections. Then right click it and select modify and enter a value of 200.

Restart your computer, if all goes well then you fixed the problem, if not, revert the changes by restoring the registry. (You may have to reboot to safe mode to do this).

Regards,
Narendra Shah.
Cyberoam,
Elitecore Technologies Ltd.

De http://old.nabble.com/No-buffer-spac...td9335358.html

pruebalo y nos cuentas

[webness]

bueno, ya lo intente en mi maquina local, y no tiene pierde seguir esas instrucciones el asunto es que tengo que hacerlo en el servidor de produccion de la empresa, tocara esperar hasta el fin de semana.


Gracias.