PostgreSQL problems

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

PostgreSQL problems

Postby snake_eyes » Fri Feb 13, 2009 4:53 am

Having followed the instructions in this thread exactly and getting no error messages, I still get the window that states 'PT3 cannot connect to any databases' when I start PT3. I have installed postgreSQL/PT3 with UAC disabled.

Any ideas?
snake_eyes
 
Posts: 64
Joined: Thu May 15, 2008 2:25 pm

Re: PostgreSQL problems

Postby kraada » Fri Feb 13, 2009 11:03 am

Is PostgreSQL currently running? Press ctrl+alt+del and click Task Manager and look on the Processes tab: do you see postgres.exe running in the list? If not, try starting it via Start --> Programs --> PostgreSQL --> Start Services. If that doesn't start it, please check to make sure your firewall/anti-virus isn't blocking PostgreSQL from starting.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PostgreSQL problems

Postby snake_eyes » Mon Feb 16, 2009 9:53 pm

kraada wrote:Is PostgreSQL currently running? Press ctrl+alt+del and click Task Manager and look on the Processes tab: do you see postgres.exe running in the list? If not, try starting it via Start --> Programs --> PostgreSQL --> Start Services. If that doesn't start it, please check to make sure your firewall/anti-virus isn't blocking PostgreSQL from starting.


Yes postgreSQL is working according to TM.
Turned Firewall off, restarted computer and still it does not work. Get the window that says PT3 cannot connect to any dbs.
snake_eyes
 
Posts: 64
Joined: Thu May 15, 2008 2:25 pm

Re: PostgreSQL problems

Postby kraada » Tue Feb 17, 2009 5:27 pm

Try following the steps of this post and see if that helps fix your issues, then.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PostgreSQL problems

Postby snake_eyes » Wed Feb 18, 2009 11:27 pm

Followed the steps but still not connecting.
snake_eyes
 
Posts: 64
Joined: Thu May 15, 2008 2:25 pm

Re: PostgreSQL problems

Postby kraada » Thu Feb 19, 2009 12:03 pm

In that case, please create a support request linking to this thread and containing the contents of the [Databases] section of your C:\Program Files\PokerTracker 3\Data\Config\PokerTracker.cfg section and we'll go from there.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PostgreSQL problems

Postby snake_eyes » Fri Feb 20, 2009 4:44 pm

kraada wrote:In that case, please create a support request linking to this thread and containing the contents of the [Databases] section of your C:\Program Files\PokerTracker 3\Data\Config\PokerTracker.cfg section and we'll go from there.


Done as requested
snake_eyes
 
Posts: 64
Joined: Thu May 15, 2008 2:25 pm

Re: PostgreSQL problems

Postby ouird » Thu Feb 26, 2009 9:58 pm

im getting this when i follow this thread.

Server doesn't listen

The server doesn't accept connections: the connection library reports
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?
If you encounter this message, please check if the server you're trying to contact is actually running PostgreSQL on the given port. Test if you have network connectivity from your client to the server host using ping or equivalent tools. Is your network / VPN / SSH tunnel / firewall configured correctly?
For security reasons, PostgreSQL does not listen on all available IP addresses on the server machine initially. In order to access the server over the network, you need to enable listening on the address first.
For PostgreSQL servers starting with version 8.0, this is controlled using the "listen_addresses" parameter in the postgresql.conf file. Here, you can enter a list of IP addresses the server should listen on, or simply use '*' to listen on all available IP addresses. For earlier servers (Version 7.3 or 7.4), you'll need to set the "tcpip_socket" parameter to 'true'.
You can use the postgresql.conf editor that is built into pgAdmin III to edit the postgresql.conf configuration file. After changing this file, you need to restart the server process to make the setting effective.
If you double-checked your configuration but still get this error message, it's still unlikely that you encounter a fatal PostgreSQL misbehaviour. You probably have some low level network connectivity problems (e.g. firewall configuration). Please check this thoroughly before reporting a bug to the PostgreSQL community.


my postgresql isnt connecting at all. any suggestions?
ouird
 
Posts: 60
Joined: Tue Mar 04, 2008 5:55 am

Re: PostgreSQL problems

Postby kraada » Fri Feb 27, 2009 10:38 am

Click Start --> Programs --> PostgreSQL --> Start Services to start the PostgreSQL service. If you don't see the "Start Services" link or the PostgreSQL folder then you don't have PostgreSQL installed and you will need to download and install PokerTracker 3 Build 4 with PostgreSQL from our download page.

If that doesn't fix it for you, try disabling your firewall and trying again; some firewalls are configured to block PostgreSQL and need to have an exception put in for the program to run properly.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 25 guests