PostgreSQL Database not opening


I tried opening my PostgreSQL database and I am getting following error:

An error has occurred:
could not connect to server: No buffer space
available (0x00002747/10055) is the server running on "localhost"
(::1) and accepting TCP/IP connections on port 5432? could not
connect to server : no buffer space avalaible (0x00002747/10055) is
the server running on "localhost" (::1) and accepting TCP/IP
connections on port 5432?

I have installed PostgreSQL in D drive. I am using PHP on Windows.

How can I solve this problem?


My PostgreSQL problem was solved the problem how means I installed the PostgreSQL in D drive so, I seriously I checked C drive space there was less memory so, I uninstalled some applications where installed in C drive after restarting my PC automatically started. But one thing we should remember where ever we install the applications like C drive, D drive and so on.. but that application acquire the C drive buffer space so, in C drive minimum space is required memory is up to 5 GB then we won't get any application error.

Best Answer

No buffer space available corresponds to a network error where the client is not enable to allocate the resources to initiate a connection.

Generally, this means that there are other programs holding too many connection handles (sockets).

According to a post on IBM developerWorks:

This error can occur on Windows, particularly around socket operations. The error is translated from the Winsock error code WSAENOBUFS, 10055. The most common cause of this error is that Windows is configured for the default maximum of 5,000 in-use ports. This can be monitored by watching netstat or perfmon and can be changed with the MaxUserPort registry parameter.

A more advanced cause for this error is non-paged pool exhaustion[...]

Uninstalling software will solve the problem for good only if that software was responsible for consuming too many simultaneous connections in the first place. Otherwise, getting back some of these resources may happen as a side-effect of say, rebooting, or just waiting a bit so that TCP connections in TIME_WAIT state disappear, or individually terminating programs that held these connections open.