PDA

View Full Version : PostgreSQL Error



cha4zz
06-09-2010, 02:37 PM
Apologies to readers, I'm fairly sure that people get this everyday but i've reached the end of my tether with PostgreSQL.

Having tried to install Holdem Manager previously and getting an error with postgre many times, I then tried to install Pokertracker3, to which got the same error. Obviously, I would rather have Holdem Manager and have come here to try and fix it.

Have followed pretty much every FAQ that is going to try and connect to the PostgreSQL database. I've disabled the firewall, have re-installed every type of software that is to do with Holdem Manager and followed the FAQ's about going into notepad all to no avail. I'm running on Vista, and when I followed the advice of someone on the Pokertracker 3 forums, it came up with something about "Postmaster" being the reason for an error.

Have sent an e-mail to support as well, but any help that I can get from anyone would be greatly appreciated. If any additional details about my system are needed please ask.

morny
06-09-2010, 11:03 PM
Im unsure if your problem is installing PostgreSQL or if its connecting to the database after you installed it, either way the following should solve it

This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it.

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 - FAQ - Hold'em Manager Poker Tracking Software :: Windows Firewall / Defender Problems (http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems) - Windows Firewall / Defender Problems

Please try following these FAQs, step by step:

1) FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (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 - FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+DatabaseReinst all) PostgreSQL Preserving Old Database
3) Still Can't Connect to PosgreSQL? Try This! - Holdem Manager Forums (http://www.holdemmanager.net/forum/showthread.php?t=8261)

If that doesn't help you will probably have to reinstall PostgreSQL completely and reimport your hands using these instructions

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe

If that version fails this version usually works fine PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.17/win32/postgresql-8.2.17-1.zip)

cha4zz
06-10-2010, 01:59 PM
It worked, command prompt answer fixed it.

You are officially my hero.