Postgresql service will not start windows 7

Run this to start a CMD. Improve this answer. Silverfire Silverfire 4 4 silver badges 14 14 bronze badges. How would I know this password? I don't remember setting one up. Humberto Castellon 1 1 gold badge 6 6 silver badges 17 17 bronze badges. I'm not sure if on typical or other installations the running user may change.

Eelke Eelke 2 2 silver badges 13 13 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks. Podcast Making Agile work for data science. Featured on Meta.

New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions. Question feed. Server Fault works best with JavaScript enabled. Accept all cookies Customize settings. If you get an "illegal system call" error, it is likely that shared memory or semaphores are not supported in your kernel at all. In that case your only option is to reconfigure the kernel to enable these features.

Although the error conditions possible on the client side are quite varied and application-dependent, a few of them might be directly related to how the server was started.

Conditions other than those shown below should be documented with the respective client application. This is the generic "I couldn't find a server to talk to" failure. Alternatively, you'll get this when attempting Unix-domain socket communication to a local server:. The last line is useful in verifying that the client is trying to connect to the right place.

If there is in fact no server running there, the kernel error message will typically be either Connection refused or No such file or directory , as illustrated. It is important to realize that Connection refused in this context does not mean that the server got your connection request and rejected it. That case will produce a different message, as shown in Section Other error messages such as Connection timed out might indicate more fundamental problems, like lack of network connectivity.

Development Versions: devel. Unsupported versions: 9. This documentation is for an unsupported version of PostgreSQL. You may want to view the same page for the current version, or one of the other supported versions listed above instead. PostgreSQL 9. Server Setup and Operation Next. Starting the Database Server Before anyone can access the database, you must start the database server.

Server Start-up Failures There are several common reasons the server might fail to start. If not, wait a few seconds and retry. Client Connection Problems Although the error conditions possible on the client side are quite varied and application-dependent, a few of them might be directly related to how the server was started. Now you need to open cmd. First run chdir and change the working directory to the location of initdb. For me, running odoo 13 on a windows 10 machine the location is this..

I first tried the latest version 11 which completely failed to install I found two pages about previous error, here and here , but they didn't seem relevant to my case, so I just started pgAdmin and, on the left "browser", saw the server wasn't active. I tried to start it from here had to type the main password , but it went inactive immediately again.

So I tried to use the Windows services panel to start "postgresql-x", no joy. I copied the command from this panel and pasted it into a Windows console cmd. In the services panel I changed the account used to start the service from Network Service to Local System as suggested in a comment by AlexanderRios. Problem solved. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 12 years, 5 months ago. Active 1 month ago. Viewed 93k times. Any idea? Erwin Brandstetter k gold badges silver badges bronze badges. David David 3, 10 10 gold badges 41 41 silver badges 52 52 bronze badges.

Add a comment. Active Oldest Votes. Jay Rizzi Jay Rizzi 4, 5 5 gold badges 38 38 silver badges 63 63 bronze badges. This worked for me too. In short: in services select the service and view its properties and change the login to local system — Alexander Rios.

See here for details: stackoverflow. Better answer: stackoverflow. You must change the data-directory during setup to avoid this problem — Anonymous.