PDA

View Full Version : HM database in cloud or LAN ?



Dirkvanb
12-18-2013, 02:10 PM
Hey,

Is it possible to setup HM1 in a way so that i can acces the database from another PC.
For example i have my desktop PC and here is my database stored.
Can i acces this from my laptop ? with LAN or also in the cloud, for when im away, travel etc ?

udbrky
12-18-2013, 02:58 PM
It is a more advanced setup, but it is possible and not too difficult.

http://faq.holdemmanager.com/questions/90/Run+PostgreSQL+Over+a+Network+

When I did this, I stored the DB on my laptop, so it would be there when I traveled, even though I played almost exclusively at home on my desktop.

Dirkvanb
12-19-2013, 04:13 PM
Verry weird, ive done these steps, it was working fine.
But after a while i got import errors, when i create a new DB it works fine for a while.

Dirkvanb
12-19-2013, 06:50 PM
Also i dont get this step



Or add a line like:
host all postgres 192.168.2.3/32 md5
(= Ip-address laptop) if you only want to access your database from inside your local network with your laptop/second computer.

This is the IP of the laptop right : 192.168.2.3
Then you need to add "/32" for some reason ?

AlphaScorpii
12-19-2013, 06:55 PM
I am also interested in cloud for HEM1. Are there any other users with helpful tips or just confirmation that it works?

Dirkvanb
12-19-2013, 09:08 PM
Ok so i think i got the problem.

Where exactly should i put this line:

host all postgres 192.168.2.3/32 md5 ??

In the file, there is this bunch of text:



# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5

Should it be, under Ipv6 or IPv4 ???

Patvs
12-20-2013, 12:18 AM
Lines with a "#" at the beginning are being ignored.
The only line that's being executed is "host all all 127.0.0.1/32 md5", so it should be under IPv4.

Dirkvanb
05-11-2014, 04:37 PM
This worked pretty good with HM1

Is it just the same for HM2 ?

Patvs
05-11-2014, 06:16 PM
It's the same...

...but HM2 also stores data in a second location, default folder is:

Windows 7: C:\Users\{username}\AppData\Roaming\HoldemManager\ Database
so if you move everything to a network drive, also move this folder.