PostgreSQL Error - Cannot connect to database

[cha4zz]

Since my desktop decided to stop working, I have taken my laptop home from university and after installing and re-installing both Pokertracker 3 and postgreSQL 8.3 and 8.4 am still getting the message - "Unable to connect to the database. Please check the configuration." Have created exceptions in the firewall, and even turned the firewall off and this has done absolutely nothing. Re-installations have done nothing either, have tried to follow a few tips that have been posted previously on here, but to no avail as well.

Any help that I can recieve, or can give so that I can help someone to help me, would be muchly appreciated.

[kraada]

Click Start (on XP click Run) type in services.msc and hit enter. In the window that appears, locate the pgsql-8.3 (or pgsql-8.4) service and attempt to start it. If it does not start, click Start --> Control Panel --> Administrative Tools --> Event Viewer and in the Application section look for an error from PostgreSQL and paste the error text here as that will help significantly in figuring out what the problem is.

If it does start, attempt to start PT3 again and see if it works for you then. If it doesn't, try following this tutorial and see if that fixes things for you.

[cha4zz]

When starting the postgreSQL 8.4, I got this notice.
s
Windows could not start the postgresql-8.4 - PostgreSQL Server 8.4 service on local computer.
Error 1053 - The service did not respond to the start or control request in a timely fashion.

Edit: Just found this in administrative tools.

2010-06-01 13:18:25 GMTFATAL: could not create lock file "postmaster.pid": Permission denied

[kraada]

Click Start --> Computer --> C: --> Program Files (x86), right click on PostgreSQL and click Sharing and Security. Switch to the Security tab then click Add, then Advanced, then Find Now. Locate the postgres user in the bottom pane and click on it, then click Ok and Ok again. With the postgres user highlighted in the top pane, click Full Control on the bottom pane and then click OK.

Restart PT3 and then everything should work properly now.

[cha4zz]

Have done exactly as you said, turned it onto full control and yet i'm still getting the same message when trying to connect to the database. Thanks for the help though anyway.

[kraada]

Then please create a support request for this issue and we will investigate further for you.

[AlexJK]

I had the same problem.

I had shared_buffers = 2048MB in my postgresql.conf. Decreasing to 512MB helped me out.

[Mtim77]

what is going on here? Event Type: Error
Event Source: PostgreSQL
Event Category: None
Event ID: 0
Date: 22.6.2010
Time: 16:02:40


Description:
2010-06-22 17:02:40 EESTFATAL: password authentication failed for user "postgres"

I cant open pokertracker,says unable to connect to database,please check config.

[Mtim77]

I had the same problem.

I had shared_buffers = 2048MB in my postgresql.conf. Decreasing to 512MB helped me out.

Did what and where? cant even see configuration on my postgres 8.4

[kraada]

Mtim,

That error means you are using the wrong password for the PostgreSQL user. Try postgrespass and see if that works, if it doesn't, follow these steps to remove the need for the password.

You can find the PostgreSQL 8.4 configuration files in C:\Program Files (x86)\PostgreSQL\8.4\data\