Choose a Username and Password:
Register
New Account
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 64.46.19.229/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!
