Database Error

Hold'em or Poker Tracker Hold'em related posts go here

Database Error

Postby Tilter » Tue Feb 17, 2009 8:22 pm

I haven't used my PT in over a month, so today when I opened it up and went to PostgreSQL Database Function I was met with this popup

"SUBJ: --Error Message --

Error #: 1
Unable to connect to PostgreSQL (Port #: 5432) to get the list of databases. The error was:
101 - SQLState = 08001
could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" and avcepting
TCP/IP connection on port 5432?

This is more likely due to the fact that the database server is not running on this port. Make sure the database server is running or, if the port is no longer being used, open the Utilities > PostgreSQL Settings window and remove the entry for port #5432 so you don't continue to get these error messages."

I go to PostgreSQL Settings and I can not remove port 5432.

How do I get rid of this error message? I would like to back up my database.
Tilter
 
Posts: 6
Joined: Sun Jun 08, 2008 3:07 pm

Re: Database Error

Postby kraada » Tue Feb 17, 2009 8:43 pm

Is that an error from PT3?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Database Error

Postby Tilter » Tue Feb 17, 2009 10:45 pm

This error was from PTv2.17.03f
Tilter
 
Posts: 6
Joined: Sun Jun 08, 2008 3:07 pm

Re: Database Error

Postby Tilter » Tue Feb 17, 2009 11:44 pm

When I click Tournament Player Statistics

I get

"SUBJ: DataWindow Error

Database transaction information not available.
Call SetTrans or SetTransObject function."

as well
Tilter
 
Posts: 6
Joined: Sun Jun 08, 2008 3:07 pm

Re: Database Error

Postby kraada » Wed Feb 18, 2009 10:53 am

You posted this thread in the PT3 section, not the PTv2 section. I'm moving the thread to the PTv2 section so Pat will see it.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Database Error

Postby ptrack pat » Wed Feb 18, 2009 2:05 pm

It means the PostgreSQL service isn't running. Go to Start > Settings > Control Panel > Admin Tools > Services
Find PostgreSQL in the list and start it.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Database Error

Postby Tilter » Wed Feb 18, 2009 6:06 pm

Hi,
I'm running XP, so I don't see the Admin Tools option.

But I do have the PostgreSQL 8.2 on my Start Menu.

One of the options are "start services" and "stop services"

I stopped and then started and then tried to open up PT and tried to open the "PostgreSQL Database Functions" and got the same error.
Tilter
 
Posts: 6
Joined: Sun Jun 08, 2008 3:07 pm

Re: Database Error

Postby ptrack pat » Wed Feb 18, 2009 7:58 pm

It's called Administrative Tools - it should be there.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Database Error

Postby Tilter » Wed Feb 18, 2009 10:13 pm

You were correct, I had to switch to "Classic View" to get to it.

I went to the PostgreSQL Database and right click -> Start

It begins to load and then the pop-up comes

"SUBJ: Services

The PostgreSQL Database Server 8.2 service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."
Tilter
 
Posts: 6
Joined: Sun Jun 08, 2008 3:07 pm

Re: Database Error

Postby ptrack pat » Wed Feb 18, 2009 10:57 pm

Go to the c:\program files\postgresql\8.2\data folder. Is there a file called postmaster.pid there? If so, delete it and then try to start the service again.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Next

Return to PokerTracker Holdem

Who is online

Users browsing this forum: No registered users and 26 guests

cron