*Little Tip for PT4 or HM database :
Let's say you are a bit paranoid like me or don't want to stress your main operating system using bunch poker tools then it can be interesting to access to your poker DB remotely.
In my case i like to use a virtual machine to use for exemple Holdem Resources Calculator and check my sessions or hands there. It can be done also from any computer of your home
network as long they are in the same sub network.
let's see how to do :
- If you have a Virtual Machine make sure the network setting is in Bridged Mode " Connected directly to the physical Network"
- Run your virtual machine and setup manually your network card using the same subnet adress usually "255.255.255.0" than your other computers , if you use a router use the same gateway
and then for the ip address choose one close to the computer you have your poker DB on , better chance to work that way. ex ( Poker DB on 192.168.0.22 , VM IP address 192.168.0.25)
- Once done go to the VM file directory and click on Network you should be able to see your other computers , if not you didn't setup your network card properly or you have a very agressive firewall
you can disable during the process and turn on back later
>>> In case you fail on those first steps there is plenty tutorials about network cards configurations / VM network setup available on the net so i won't go too deep about it.
Now you can see the remote computer who holds your poker DB.
- Get on the computer you have your poker DB on
- Go to search bar and type Services and click on the app
- Scroll down the Services window and you will see postgresql-x64-9.3 ... Server or something like it depending on versions you have and OS
- Right click on it and click on Stop then wait a little
- Keep the service window we will need it to restart the DB server later
- Go to your file directory to that location " Your main Hard Drive directory X:\Program Files\PostgreSQL\9.3\data"
- Make a backup of the files "pg_hba.conf" and "postgresql.conf"
- Open your favorite text editor in Admin mode and open "postgresql.conf"
- Check if you find a line starting like this "listen_addresses = '*'" if not add >> listen_addresses = '*' at the bottom of the file and save it
- Open then "pg_hba.conf" and add at the bottom >> host all all 192.168.0.0/24 md5 at the bottom of the file and save it
Obviously if your ip address is something like 192.168.1.X then replace 192.168.0.0 by 192.168.1.0
- Back to the Services window we opened earlier
- Right click on postgresql-x64-9.3 and click on Start
- Reboot your computer
Done
- Open your virtual machine or get on your remote computer
- Run HRC or your fav tool
- Import Hands or Tournaments from SQL Database
- enter the ip address of the computer containing your poker DB
And it's all done and you can review your sessions ♠_cool:
P.S : if you messed up editing the config files you can restore the backup in the file directory and reboot so everything go back to normal