Solve the problem of 100% CPU card dead after PostgreSQL service starts

Time:2019-6-23

There are N postgres. exes in the process (this is normal, see official documentation), but one is always full of CPU (because the machine is dual-core, occupying 50% of the resources). The pgAdmin III connection that comes with it will die.

The question was not answered by an online search.

Looking at the log, we found such an error message:

%t LOG:  could not receive data from client: An operation was attempted on something that is not a socket.

According to the error prompt, we found the answer on HP’s official website (it should be Win’s question, but it was interesting to find the answer here) (http://h10025.ww1.hp.com/ewfrf/wc/document? Docname = c00724449 & LC = zh-hans & DLC = zh & CC = TW & Product = 86191 & lang = zh):

Step 1: Reset Winsocks
By resetting the Winsock layer, browsers can use URLs to find web pages. Use the following sections according to your Windows version.
Computer with Windows XP Service Pack 2 or higher installed
If Windows XP Service Pack 2 or later is installed, perform the steps in this section. If Service Pack 2 is not installed, skip to Step 2.
Click Start, and then click Run.
In the Open tab, type: Netsh Winsock reset
Click OK and restart the computer.
——————————————————————————–
Open cmd, run Netsh Winsock reset, restart computer, troubleshooting!