Page 1 of 1

Unable to Connect to PostgreSQL - WinXP

PostPosted: Mon May 25, 2009 11:40 pm
by snoopdarr
I recently tried to run PT3 for the first time in a few weeks. I got the error that I am unable to connect to PostgreSQL. The only significant change (I think) I have made in that time was uninstalling AVG av and installing avast! av.

I found in these forums how to uninstall/reinstall Postgre, which I followed and it completed, but did not help. I then tried uninstalling everything, and reinstalling the full PT3 (latest normal build, not beta) and I get the same error. PostgreSQL is installed, and the several processes are running.

I must admit I know little about PostgreSQL and only installed it when I upgraded from PT2 to PT3. I don't really get what's going on in the "pgAdmin III" tool. When I'm in there, I can connect to the DB server (at localhost:5432), and it shows "PT3 DB" under databases. But pgadmin never says "Yes" next to "running", even if I tell it to "Start Service". What is wrong?

Re: Unable to Connect to PostgreSQL - WinXP

PostPosted: Tue May 26, 2009 10:17 am
by kraada
Make sure that Avast! has built in exceptions to allow C:\Program Files\PokerTracker 3\PokerTracker.exe, C:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe and C:\Program Files\PostgreSQL\8.3\bin\postgres.exe full access; if the latter two files can't access port 5432 then PostgreSQL won't be able to start.

Re: Unable to Connect to PostgreSQL - WinXP

PostPosted: Tue May 26, 2009 1:15 pm
by snoopdarr
Yes, PT3 and PostgreSQL are listed as exceptions. Just for fun, I uninstalled avast! altogether, and it didn't fix it. What next?

Re: Unable to Connect to PostgreSQL - WinXP

PostPosted: Tue May 26, 2009 2:09 pm
by kraada
Attach the last 5 files in the C:\Program Files\PostgreSQL\8.3\data\pg_log folder zipped up to a support ticket and we'll go from there.

Re: Unable to Connect to PostgreSQL - WinXP

PostPosted: Tue May 26, 2009 2:19 pm
by snoopdarr
Done!

Re: Unable to Connect to PostgreSQL - WinXP

PostPosted: Tue May 26, 2009 2:44 pm
by kraada
Thanks, we'll get back to you in your ticket.

highfalutin