PokerTracker2 and HoldemManager PostgreSQL Database Connection
Only PokerTracker2 and HoldemManager are currently supported
This page shows you how to setup your end so that weaktight.com can connect to your PokerTracker/HoldemManager Database. This is used to get profile information for the
hands that you post or convert on weaktight.com. These stats include such things as: hands played, percentage hands raised, and aggression.
Before you start here, it is assumed that you have PostgreSQL version 8.0 or better installed and that you have a PostgreSQL database already setup in PokerTracker/HoldemManager. If you're using PokerTracker and you don't have PostgreSQL setup, you'll need to follow PokerTracker's short guide:
Step 1 | Open your port
You must configure your computer to accept connections on the PostgreSQL port. By default, this port is 5432. If you have a router, you must make sure that this port is open for traffic. For details on how to do this, see: http://www.portforward.com/.
It must also be open in your Windows Firewall if that is enabled. The Windows Firewall is found under: Start > Control Panel > Windows Firewall. Open the Exception tab and click "Add Port". Choose a name, set the port to 5432 and select TCP. If you have any other software firewalls running on your system, you'll have to add exceptions to them as well.
Step 2 | Set your server to listen for connections
Next, if you haven't done so, I suggest backing up your PokerTracker/HoldemManager PostgreSQL database before proceeding. We need to tell our PostgreSQL host that we're accepting external connections. To do this we need to edit our pg_hba.conf file that is part of PostgreSQL. There is a link to this file in your Window's start menu under your PostgreSQL install: Start > Programs > PostgreSQL > Configuration files (Something like: C:\Program Files\PostgreSQL\8.0\data\pg_hba.conf). We want to add the following line to allow connections from weaktight.com explicitly. These connections are only accepted with the correct password to your server:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
host all all 126.96.36.199/32 md5
Finally, we need to enable remote connections to our server. In postgresql.conf (Something like: C:\Program Files\PostgreSQL\8.0\data\postgresql.conf) you'll find the following line:
# listen_addresses = 'localhost'
To allow weaktight.com to connect, we need to change it to:
listen_addresses = '*'
Note that the # has been removed. Only weaktight.com will be able to connect to your database remotely.
Restart your computer for this to take effect.
Step 3 | Test your connection
If you're setup correctly, your PostgreSQL port should be open. To test this, you can enter your port on this page: http://whatsmyip.org/ports/. It should read "Open". Fill out the form below with your PostgreSQL details and hit submit to test a connection to your database!