Videos / Other Resources

No attachments were found.

Can't Connect / Failed to Start PostgreSQL

Overview:

Quick Solution

Basic PostgreSQL Troubleshooting

Testing PostgreSQL Connection

PostgreSQL Still Doesn't Work  (Read the FAQ Below First)



Delete Postmaster.pid file
Please delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it. The file may not be there but please Do Not delete any other files with similar names




Quick Solution

 

Many of the past compatibility problems associated with Windows and PostgreSQL can be solved by using our latest Combo installer. (Download Combo Installer)  This installer will rename your old PostgreSQL folder so you may have to reimport your hands once you've fixed your PostgreSQL problem.  If you want to try and solve the problem without losing your database, read the rest of this FAQ.

 

 

 



This FAQ is for any of the following PostgreSQL problems:

 

  • Failed to establish a connection to ‘127.0.0.1’ Service 'PostgreSQL Database Server 8.x' (pgsql-8.x) failed to start. Verify that you have sufficient privileges to start system services

 

  • Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host 

 

  • The PostgreSQL Database service started then stopped, Some services stop automatically if they have no work to do...

 

  • Windows just updated and PostgreSQL doesn't work anymore 

 

  • Or any PostgreSQL type error when trying to open Holdem Manager

 

 

 


Basic PostgreSQL Troubleshooting

Note:  Make sure (UAC) User Account Control is off before proceeding.  See the following links for information about UAC.

 

Windows 7 UAC Help

Vista UAC Help



Restart PostgreSQL service & Reboot

Go to Start > Programs > PostgreSQL > 8.x > Stop Service (If its already started)
Then go to Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file (it may not be there, that is perfectly fine)
Finally, if none of the above works a simple reboot can often resolve the issue

 


99% of the time PostgreSQL connection problems can be fixed by completely uninstalling software security products. 

You can also enable features inside of your software security products without completely uninstalling them.  Details Here


We suggest you completely uninstall:  (Don't just disable these products!!!) Disabling these products doesn't work because they are still running in the background.  Reboot after uninstall too.

  • Antivirus (Avast & AVG are free solutions with no known problems)
  • Spyware Tools
  • 3rd Party Firewalls

 

Note: Mcaffe, Comodo, F-Secure, Panda and Norton are the worst offenders here.  If you are getting the errors and have 1 or more of these products installed, there is a very good chance that once these Antivirus programs are completely removed from your PC, PostgreSQL and Holdem Manager will be working together again.

 

Note:  If you're a Software Security nit, chances are you have a couple antivirus programs with a couple spyware programs.  Uninstall everything for now.

 

Note:  Once PostgreSQL is working, we can install Software Security programs, but only 1 at a time testing our PostgreSQL connection each time.

 

 


Logon using Local System Account:

 



1. Go to Start / Control Panel / Administrative Tools (Need to be using classic view in Windows Vista) / Services. The Services dialog will pop up.

2. Scroll to PostgreSQL Database Server. If it isn't started (as indicated in the status column) right click on it and choose Start. If it starts and then stops or was already started, follow the steps below:

3. Right click on PostgreSQL Database Sever and choose Properties. You should see the following dialog.

4. Click on the Log On tab. Copy the username in the This Account field and paste it into Notepad in case you need to use it again. Make sure you know your password as well.

5. Select Local System Account and then click Apply then OK.

6. Restart your PC and see if you still get the error.

7. If it does not fix it, please switch to logon as This Account and enter your username and password again and reboot and continue with the rest of the FAQ.

 

 


Testing PostgreSQL Connection:

 

While there's multiple ways to do this, the easiest is to just open Holdem Manager.

  • Launch Holdem Manager


If Holdem Manager opens you are done.

If you still get a PostgreSQL error, PostgreSQL is not connected or working.





Still Not Working?

Now we need to rule out the following:

 

If none of those worked Please reboot and try following these FAQs, step by step:
1) http://faq.holdemmanager.com/questions/91/Can’t+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+ Can’t Connect / Failed to Start PostgreSQL
2) Reinstall the same version of postgresql, using the same \data folder – http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+DatabaseReinstall PostgreSQL Preserving Old Database
Failing that you will probably have to reinstall PostgreSQL completely and reimport your archived hands using these instructions. Once you do this you won’t have access to the hands in the old database but since you can’t connect to the database your already in that situation. In the case it’s not possible to reconnect you can either contact the PostgreSQL forums who may be able to help with advanced connection issues or you can reinstall. I’ve listed 3 PostgreSQL forums below
http://forums.devshed.com/postgresql-help-21/
http://old.nabble.com/PostgreSQL-f759.html
http://www.dbforums.com/postgresql/
1) Uninstall PostgreSQL via Control Panel > Programs & Features (Add/Remove Programs on XP).
2) Use our combo installer to reinstall PostgreSQL.  Make sure you un-check Holdem Manager during installation.  http://rvgsoftware.fileburst.com/Holdem_Manager_Setup.exe
If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
The secondary logon service is a standard windows service which is available on every windows computer and is required to be running to install PostgreSQL. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.
Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
In the window that appears please type the following and press enter:
net user postgres /delete
Try installing this version of PostgreSQL – http://rvgsoftware.fileburst.com/Postgres_8.3.9-v1.0.7.exe
If that also fails Please follow step A again and try this version 
http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip
If none of those worked Please reboot and try following these FAQs, step by step:
Reinstall the same version of postgresql, using the same \data folder – http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+DatabaseReinstall PostgreSQL Preserving Old Database

Fresh Reinstall of PostgreSQL
Failing that you will probably have to reinstall PostgreSQL completely and reimport your archived hands using these instructions. Once you do this you won’t have access to the hands in the old database but since you can’t connect to the database your already in that situation. In the case it’s not possible to reconnect you can either contact the PostgreSQL forums who may be able to help with advanced connection issues or you can reinstall.

I’ve listed 3 PostgreSQL forums below:
http://forums.devshed.com/postgresql-help-21/
http://old.nabble.com/PostgreSQL-f759.html
http://www.dbforums.com/postgresql/
1) Uninstall PostgreSQL via Control Panel > Programs & Features (Add/Remove Programs on XP).
2) Use our combo installer to reinstall PostgreSQL.  Make sure you un-check Holdem Manager during installation.  http://rvgsoftware.fileburst.com/Holdem_Manager_Setup.exe

Check Secondary Installer Service is running: 
If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
The secondary logon service is a standard windows service which is available on every windows computer and is required to be running to install PostgreSQL. In the latest versions it is not started automatically.

You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.
Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
In the window that appears please type the following and press enter:
net user postgres /delete
Try installing this version of PostgreSQL – http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe

If that also fails Please follow step A again and try this version - http://ftp.postgresql.org/pub/binary/v8.2.23/win32/postgresql-8.2.23-1.zip

 

 

  

 

 

| More

Related Articles


User Opinions (104 votes)

75% thumbs up 25% thumbs down

How would you rate this answer?



Thank you for rating this answer.

Visitor Comments

No visitor comments posted. Post a comment

Post a comment

To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.
   Name:
   Email:
* Comment:
* Enter the code below:
 

Continue