Is there a way to synch HM on 2 computers?

[Arizona Willie]

Just installed HM on my laptop running Windows 7 64 bit and wondered if there is any way to synch both computers.

I mostly play during the day using the desktop, but would like to play sometimes at night while watching tv using the laptop.

Would like to be able to have all the info I have on the desktop available on the laptop when I use it. And then, if using the desktop the next day, have the info from the previous night's session on the laptop on the desktop.

We need a synchronize button :D

[_Loki_]

I think this is how I would do it although I haven't gone into it deeply - Make your desktop the DB server & when you run HEM on your laptop it uses the DB on your desktop

Network your laptop & server together by wire or over the internet or by wi-fi

Of those 3 options I would use WiFi because - no wires, it's very easy to set up with the new routers, it's reliable & it's safe (if you apply what it says in the 2nd link)

FAQ - Hold'em Manager Poker Tracking Software :: Run PostgreSQL Over a Network (http://faq.holdemmanager.com/questions/90/Run+PostgreSQL+Over+a+Network+)

Wireless Security - WiFi Wireless Home Network Security Tips (http://compnetworking.about.com/od/wirelesssecurity/tp/wifisecurity.htm)

[Arizona Willie]

Ran into a problem trying to follow the instructions.
It says to add a new line to the postressql.conf file but it won't let me.
When I open that program it wanted a file that I found in the data directory and loaded it but there are many many many options there with most of the boxes unchecked. There was a box for list address and I checked then and entered the ip addresses of the desktop and laptop separated by a comma. Don't know if that is right or not.

But the instruction after that says to add a line and I can't. Tried help etc. but find no way to add a new line. Clicking on the small blank space at the end of the list does nothing. Right click doesn't work either.

It appears the instructions for Windows 7 may be different, dunno.

I'm still using postres 8.3 but most of the instructions seem to show that so it ought work but it doesn't. Not sure if listing the ip addresses was correct or not. Can't add the new line like it say.

What should I do next?

[_Loki_]

Hi Arizona

I've never attempted to do what you are doing - I don't have network knowledge. So... I may be misunderstanding your post so forgive me if I'm writing stuff you know (or stuff that's wrong) :)

posgresql.conf file:
you are only being asked to modify the a* line in that file
I'm not sure which is the 'listen address(s)' though. I don't know if it's right to put 2 in one line. I would have thought you put your servers static IP address in there only just as it says in the FAQ (or at least that's how I interpret it)

you are not being asked to add a line in the posgressql.conf file, but in the pg_hba.conf file
when I open my pg_hba.conf file I have two filled-in lines & box in the 3rd line - highlight & double click that line & you get a popup with drop-down boxes so that you can design a new line
repeat the process to get the same as shown in the faq

[Arizona Willie]

no luck so far.

I did manage to get it so HM wouldn't even run :confused:

finally managed to undo the changes and got HM running again on the desktop.

I removed the postgres from the laptop entirely to make sure it couldn't access a local database. If it ever works it will be over the network.

I was under the impression ( probably mistaken ) that we had to put a check in the box for listen addresses in the postgres.conf file and then list the addresses we wanted it to listen to and also put them in the pb_hba.conf file.

Hmmm, maybe I'll take another shot at it this afternoon.

[morny]

It says to add a new line to the postressql.conf file but it won't let me.

Not really sure whats going on there, can you post a screenshot to illustrate?

[Arizona Willie]

That problem eventually got resolved. Dunno what was going wrong.

But I still haven't gotten it working from the laptop over my wireless network.

Going to try again in a bit.

[Arizona Willie]

I just noticed that when I installed HM on the laptop it installed postgres 8.4 and i'm using 8.3 on the desktop.

I have since removed postgres from the laptop so that probably shouldn't make a difference, unless HM is looking for an 8.4 version of the postgres because it was installed with that.

Do I need to update my postgres to 8.4?

[morny]

No need to update unless your having issues or something like that but its not neccessary

[Arizona Willie]

On the desktop

I put the * in the postgressql.conf file.

I open the pg_hba.conf file in pgadmin III and the Backend Access Configuration Editor comes up and I load the pg_hba.conf file.

I add the line host all postgres 192.168.1.102 md5

I start and stop the service

All according to instructions.

When I start HM on the laptop I get this error:

http://i816.photobucket.com/albums/zz85/arizwillie/postres%20errors/error1.jpg

If I close that error and click < connect > again I get this error:

http://i816.photobucket.com/albums/zz85/arizwillie/postres%20errors/error2.jpg

In desperation I have used the edit pg_hba conf found under PostgreSQL on the all programs menu which loads the file into Notepad.

I have it looking like this:

http://i816.photobucket.com/albums/zz85/arizwillie/postres%20errors/error4.jpg

When I go back into PGAMIN III and reload the pg_hba.conf file it comes up like this:


http://i816.photobucket.com/albums/zz85/arizwillie/postres%20errors/error3.jpg

The last line in the flle does not show up even though it was put into the pg_hba.conf file by using the Backend Access Configuration Editor!!

I put the line in the editor and saved it and stopped and started the service and when I looked at the pg_hba.conf file in Notepad the line was added at the end, but when I reload it it does not show in the editor.

And everything crashes when I try to run it from the laptop.

I have tried it with HM runing on the desktop and not running on the desktop.

Just can't get it to work. Don't understand why the correct line that IS in the pg_hba.conf file doesn't show up when loaded in the editor.

Oh yea, I have disabled the firewall on the desktop and it made no difference.

Does postgres have to be on the laptop too even though it is not being used as I am attempting to use postgres on the desktop over the network?

[_Loki_]

out-of-my-depth-time...
I'm on really shaky ground here

192.168.1.102 is your D-Link (or whatever) routers ip ?
That isn't a static ip ? (that seems to be important in the original FAQ)
that ip is mentioned a lot if you google it so it can't be a static ip

I think you need to post on postgreSQL forum

this link mentions 192.168.1.102 & connecting from 'outside the network' & all sorts of stuff I haven't a clue about :)
http://ubuntuforums.org/showthread.php?t=360017

[morny]

Also the problem with not being able to change certain things sounds like a permission issue, try right clicking on the postgreSQL folder and edit the permission so all the users have full access and see if that helps

[Arizona Willie]

Also the problem with not being able to change certain things sounds like a permission issue, try right clicking on the postgreSQL folder and edit the permission so all the users have full access and see if that helps

===========
No, I've already made sure that was all shared.

[Arizona Willie]

out-of-my-depth-time...
I'm on really shaky ground here

192.168.1.102 is your D-Link (or whatever) routers ip ?
That isn't a static ip ? (that seems to be important in the original FAQ)
that ip is mentioned a lot if you google it so it can't be a static ip

I think you need to post on postgreSQL forum

this link mentions 192.168.1.102 & connecting from 'outside the network' & all sorts of stuff I haven't a clue about :)
I can se my page with 192.168.1.102 but not with the router's ip =( help - Ubuntu Forums (http://ubuntuforums.org/showthread.php?t=360017)

==============
They seem to be talking about being able to see a web page. Don't think that's about postgres.

Reckon maybe I can google postgres and find its home and maybe a support forum there.

[_Loki_]

This is quite good because it explains some things in plain(ish) language
PokerTracker &bull; View topic - How To: Network PostgreSQL Database (http://www.pokertracker.com/forums/viewtopic.php?f=45&t=4638)

I found it in this thread - which is where the FAQ I suggested was born
http://forums.holdemmanager.com/manager-general/2210-accessing-postgres-over-network-2.html
It also helps cast a bit of light about static ip in post 10 maybe

If you open pgAdminIII & go into help it will take you to a LOT of documentation & a useful set of FAQ's - have a look at section 4 ?

US Support group send a mail to post a query to here pgus-general@postgresql.org
PostgreSQL Mailing Lists: pgus-general (http://archives.postgresql.org/pgus-general/)

There's also Denver:
PostgreSQL Mailing Lists: diapug (http://archives.postgresql.org/diapug/)

[Arizona Willie]

Thanks so much Loki, the link to the pokertracker info was what I needed.

I had been using an address like 192.189.1.102/32 and the /32 should have been /24.

Changed that and everything is now working just fine.

I can use Holdem Manager from my desktop or my laptop and have all my statistics available on either machine. Don't lose any hands when playing on the laptop now because it is actually using the database on the desktop.

All that about a static IP is of no concern when talking about using HM on your home / local network. Only if you want to access the database over the internet like say you leave your computer on at home and go to Chicago and want to play using your laptop you could use the database at home if you have a static IP.

My cable company says we have dynamic addresses but everytime I check it is always the same.

But the addresses of the network behind the router are static ... they never change so you don't really need to worry about that.

But this is the way the line that caused the trouble should be:

host all all 192.168.1.XXX/24 md5

That line and change the listen_addresses to * and that's all it really takes to use Holdem Manager / postgres through the whole house ... oh and add postreSQL to your firewall allowed programs. I'm using AVG's firewall ... very easy to add a program.

Thanks again to all who assisted. :D

[_Loki_]

Arizona. I'm really pleased that you got up & running

I may well want to try this network lark - when you have an hour could you take this FAQ below & paste it back into this thread with your notes added into the FAQ on what you did ?

FAQ - Hold'em Manager Poker Tracking Software :: Run PostgreSQL Over a Network (http://faq.holdemmanager.com/questions/90/Run+PostgreSQL+Over+a+Network+)


IMO - The FAQ doesn't explains well why certain steps are necessary & it is too full of network jargon for me (yeah yeah I know it's for advanced users :) ) - to put it another way the FAQ is OK on the how, but poor on the why which means it's difficult to adapt the instructions to individual needs

Also - What router did you use, how & why ?

Thanks

[Arizona Willie]

Loki, I added a comment to the FAQ.

[_Loki_]

Thanks Arizona. On the FAQ it says: Visitor Comments:


No visitor comments posted. Post a comment (http://faq.holdemmanager.com/questions/90/Run+PostgreSQL+Over+a+Network+#content)

I suppose they are moderated first before being viewable

[morny]

Yeah there moderated, ill be reviewing some faqs over the coming week so ive added this to my to do list