Page 1 of 2

PostgreSQL Won't Connect

PostPosted: Fri Jul 10, 2009 9:37 pm
by cbe2869
Followed all instructions to install 8.3 with UAC turned off. Everything installed correctly but will not connect. I keep getting

Server doesn't listen.

could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?

I've tried stopping and restarting the service. Nothing. Please help. Very frustrated. Thanks.

Re: PostgreSQL Won't Connect

PostPosted: Sat Jul 11, 2009 4:14 am
by WhiteRider
What firewall are you using? Some of them can prevent the postgres service from starting or working correctly.
Try disabling your firewall temporarily while you start PT3.

Re: PostgreSQL Won't Connect

PostPosted: Sat Jul 11, 2009 4:46 am
by cbe2869
Just Windows firewall. I turn it off and nothing. When I start PT it just says

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?

Re: PostgreSQL Won't Connect

PostPosted: Sat Jul 11, 2009 4:53 am
by WhiteRider
Do you have any postgres processes in Task Manager > Processes?
If not, go to Start > Programs > Postgres > Start Service.
Do you see any now?

If not, then something is preventing postgres from starting.
Please select the last few files in C:\Program Files\PostgreSQL\8.3\data\pg_log (they're dated so just pick the recent ones), right-click and choose 'Send To Compressed/zipped Folder', then attach the zip file to a ticket on the Support system, and link to this thread in the reference field of the ticket so that we can investigate.

Re: PostgreSQL Won't Connect

PostPosted: Sat Jul 11, 2009 5:35 am
by cbe2869
Nothing running under processes. When I try to start the service a prompt window opems for a split second, then closes, and still nothing running under processes. I'll send the files in a support ticket.

Re: PostgreSQL Won't Connect

PostPosted: Sat Jul 11, 2009 5:50 am
by cbe2869
It won't even let me open the individual pg_log files. It says access denied. The last file is from 6-4-09.

Re: PostgreSQL Won't Connect

PostPosted: Sat Jul 11, 2009 6:00 am
by WhiteRider
That really sounds like a permissions issue - are you sure you had UAC disabled when you re-installed, and that you're running postgres as administrator?

Please schedule a remote assistance session where someone can logon to your computer with you and directly troubleshoot/resolve the issue.

Re: PostgreSQL Won't Connect

PostPosted: Sat Jul 11, 2009 6:59 am
by cbe2869
Had UAC turned off the whole time. I'm trying uninstalling everything and reinstalling one more time. When reinstalling now though I'm getting something that when it says activating procedural languages it says

Error
Failed to connect to the database. Procedural languages files are installed but are not activated in any databases.

Re: PostgreSQL Won't Connect

PostPosted: Sat Jul 11, 2009 7:49 am
by WhiteRider
I'm not an expert in this - did you follow the directions in this post? How to reinstall Postgres
Are you installing the English version of postgres?
If you request a remote session one of our postgres experts will help you out.

JHH Re: PostgreSQL Won't Connect

PostPosted: Sun Jul 26, 2009 10:13 pm
by SugarHooves
Hi,

I have PT2 version v2.17.03b.

Getting same error message of:

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?

but different background, i.e.: there is no pg_log more current than 7/12/09. Why? Because ...

Have had all my poker related software apps/data installed on secondary drive, called 'F Fran' for 5 years plus. Make incremental backups daily of everything on this 'F Fran' hard drive. The 'F Fran' hard drive crashed. Minor sweat I thought, because of full backup. Great opp to get better hard rive.

Got new hard drive. Copied everything over from backup to new hard drive with same name. Everything appears the same but ...

After Start Postgres service and then start PokerTracker v2 continue to get the same error message as shown above.

I have gone manually to 'services.msc' and Postgre service was set to Manual. Even after I 'Start' it, no change, same error message in PT2.

Ideas? Suggestions?

Thanks.

John

highfalutin