Solve the problem of 100% CPU PostgreSQL after service startup _postgresql

Source: Internet
Author: User
Tags pack postgresql

There are n Postgres.exe in the process (this is normal, see the official document), but there is always a full CPU (because this machine is dual-core, occupies 50% of the resources). The Pgadmin III connection will die out.

The problem did not find an answer on the web search.

Viewing the log found an error message:

%t log:could not receive data from Client:an operation being attempted on something ' not ' a socket.

According to the error, found the answer on HP's website (should be the question of win, but found the answer here, very interesting) (http://h10025.www1.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, the browser can use the URL to find the Web page. Use the following related sections based on your version of Windows.
Install Windows XP Service Pack 2 or higher computers
If you are installing Windows XP Service Pack 2 or later, follow the steps in this section. If you do not have Service Pack 2 installed, skip to step 2.
Click "Start" and then click "Run".
In the Open key, type: netsh winsock reset
Click OK, and then restart the computer.
--------------------------------------------------------------------------------
Open cmd, run netsh winsock reset, reboot the computer, troubleshooting!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.