PostgreSQL/Pokertracker problem - Gambling and Poker Software Forum

Two Plus Two Forums Online Poker Sites & Marketplaces Poker Software General Software Discussion

PostgreSQL/Pokertracker problem

Post Reply Subscribe

...

03-09-2008 , 12:18 AM

bluef0x

Politics Forum FFB Champ

Join Date: May 2005 Posts: 9,483

So a couple of weeks ago I opened up PT and received a "Database Error" that said the following:

Unable to connect to the database.
101 - SQLSTATE = 08001
could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?

I couldn't figure out how to fix the error, so I installed a new PostgreSQL and made a new database. All was fine for a week and now I just received the same error.

What is causing this?

Quote

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

03-09-2008 , 04:37 AM

Gesu`

newbie

Join Date: Feb 2008 Posts: 21

Usually this happens when PostgreSQL is not running. Try to stop and then restart it, using shortcuts in *Start | Programs | PostgreSQL*. Then restart Poker Tracker.

If this does not work the problem could be in the port unreacheable: check your firewall or other settings that could block access to the port used by Postgres.

Quote

03-09-2008 , 12:57 PM

bluef0x

Politics Forum FFB Champ

Join Date: May 2005 Posts: 9,483

Quote:

Originally Posted by Gesu`

The service is stopped, but I can't restart it. I've tried using the start menu approach, the postgresql command prompt, windows command prompt, control panel, etc. I can't get PostgreSQL to start again.

Quote

03-09-2008 , 04:33 PM

Mido Ps

adept

Join Date: Nov 2006 Posts: 870

have you defrag your PC lately? This happened to me once, after that I'm backing-up my database daily.. lol

Quote

03-09-2008 , 07:08 PM

Lateksi

adept

Join Date: Jun 2007 Posts: 853

PT2 isn't fully compatible with PSQL 8.3 yet, I had similar problems when updating from 8.2 to 8.3.
You could try this:
http://www.pokertracker3.com/forums/...=+backup#p6061

Quote

04-08-2008 , 04:26 PM

Evaneezerscrewed

newbie

Join Date: Apr 2008 Posts: 19

Has anyone used holdem manager? im having trouble setting it up. if anyone can offer a hand thatd b nice. or even a better place to ask. thx

Quote

04-08-2008 , 04:37 PM

Dazarath

Pooh-Bah

Join Date: Nov 2004 Posts: 4,659

You definitely don't want to uninstall/reinstall PGSQL everytime you get this error. It happens quite frequently to me. Try closing all programs which would use PGSQL, like PT2, PT3, HM, PEV, PAHUD, etc. Then go to start > programs > postgresql > stop service. Then restart the service by going to start > programs > postgresql > start service. See if that works.

Quote

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

Post Reply Subscribe

...