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?
Update:
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:
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.