PDA

View Full Version : HM can't get PostgreSQL to start



Necrophecy
11-26-2008, 07:01 PM
I'm using HM 1.06.04 rc 9 & PostgreSQL 8.3.5 - both of which I just updated today but the following problem already existed.

When I started HM this morning I got the "Failed to establish a connection ..." error and went through the connection procedure including having HM attempt to start the service but it didn't work.

Event Viewer is showing the following error whenever I try to start it up - 2008-11-27 07:04:09 EST FATAL: could not open directory "pg_tblspc": No such file or directory

I Googled that file/directory name but I can't really find anything helpful - or at least all of the information is too complex for me to understand :(

Any help would be appreciated.

j2j2
11-26-2008, 08:27 PM
i am having the same problem. i am using xp not vista and i think i did everything right from this faq thing

http://www.holdemmanager.net/faq/afmmain.aspx

and then the follow up one that is mostly just for vista.

then i tried to uninstall both postgressql and holdem manager and reinstall them, and that didnt work either :( haaaaaaaalp plz

fabio
11-26-2008, 10:40 PM
Just go to C:\Program Files\PostgreSQL\8.3\data and create a folder named "pg_tblspc" and everything should be fine

Necrophecy
11-26-2008, 11:12 PM
That hasn't helped unfortunately. I'm now getting different errors:

2008-11-27 14:08:52 EST FATAL: database files are incompatible with server
2008-11-27 14:08:52 EST DETAIL: The database cluster was initialized without HAVE_INT64_TIMESTAMP but the server was compiled with HAVE_INT64_TIMESTAMP.
2008-11-27 14:08:52 EST HINT: It looks like you need to recompile or initdb.

If by "recompile" it means re-install then I tried that and nothing changed.

fabio
11-26-2008, 11:49 PM
Please email me at fabio@holdemmanager.net to arrange a date and time for a Teamviewer session so I can help you.

j2j2
11-27-2008, 12:03 AM
i got my issue figured out kinda

Nenrode
06-19-2010, 09:45 PM
FABIO i need help too. Can we arrange a session with teamviwer?

netsrak
06-20-2010, 06:26 AM
Please explain your problem in detail and check our faq first:

FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can%27t+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+)

FAQ - Hold'em Manager Poker Tracking Software :: Software Security Problems (Firewall) (http://faq.holdemmanager.com/questions/339/Software+Security+Problems+%28Firewall%29)

Nenrode
06-20-2010, 10:15 PM
I checked your faq and did everything.

I can't start HEM because postgres doesnt connect and i cant install it as well and if i try to reinstall it fails to complete. So i would really apreciate if you could help me with this problem because i can't find an answear on your site.

netsrak
06-21-2010, 03:16 AM
Do you have Postgresql installed and is the postgresql service running?

Are you using any firewall or other security software?

Nenrode
06-21-2010, 03:40 PM
yes Ive tried everything even disabling the firewall. I received an email with HEM help but nothing worked.

morny
06-21-2010, 07:07 PM
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 doesnt work tell me whats the last thing you done and what the error/problem was