PDA

View Full Version : Failure to establish connection to hem...



smbsmbsmb
02-16-2011, 09:28 PM
Hi,

Have had similar a similar problem before which was fixed for me by a friend but I need some help with it again. I'm getting the error message:

The following error occurred when trying to open the database: failure to establish a connection to "xxx.x.x.x"

Then when being prompted, an attempt to connect to the postgresql fails followed by holdem manager being unable to start the service.

Any help would be greatly appreciated.

Cheers.

olliepower
02-16-2011, 10:16 PM
This is usually a firewall or windows update issue and the following guide will help you to fix this problem.

Go to Start > Programs (or all programs) > PostgreSQL 8.x > choose Stop Service

Start > Programs (or all programs) > PostgreSQL 8.x and choose Start Service. This may take some time and a black dos window may appear while it?s starting. If it fails to start delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it. Do not delete any other files

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily ? http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems - Windows Firewall / Defender Problems

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+DatabaseReinst all 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
PostgreSQL Help Forums (http://forums.devshed.com/postgresql-help-21/)
PostgreSQL (http://old.nabble.com/PostgreSQL-f759.html)
PostgreSQL - dBforums (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 PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.17/win32/postgresql-8.2.17-1.zip)