PDA

View Full Version : Multiple users connected to same database



Karl
09-04-2008, 11:17 AM
I have two users from remote computers connected to my postgres database and HEM importing simultaneous from both users. It doesnt relly work and one users gets tons of import errors. From a postgres point of view, it should work. Does HEM have some limitations making this setup impossible?

backisen
10-26-2008, 03:28 PM
Bump

morny
10-26-2008, 03:35 PM
Shouldnt be a problem from HM's point of view but im not sure about PostgreSQL but id imagine it should do, import errors wouldnt really have anything to do with PostgreSQL, that might have been a seperate issue

Karl
10-26-2008, 03:57 PM
I think you have to take into consideration multiple users connected at the same time when writing the DB-code.. Pokertracker made the mistake of deciding the enumeration in the tables by itself, instead of asking Postgres about what number is should use. That made the numbers collide when running two users. Chances are HEM works the same way if not specifically written for multiple user.. So, is it?

backisen
10-27-2008, 06:32 AM
I think you have to take into consideration multiple users connected at the same time when writing the DB-code.. Pokertracker made the mistake of deciding the enumeration in the tables by itself, instead of asking Postgres about what number is should use. That made the numbers collide when running two users. Chances are HEM works the same way if not specifically written for multiple user.. So, is it?

This question is really interesting. I Hope you can look into this morny.

morny
10-27-2008, 10:42 AM
Ok im not sure about this so ive escalated it to Roy and hell respond asap

Rvg72
10-28-2008, 01:20 AM
Guys, as long as everyone is using the same version it will be fine. If someone is using a 1.06.03 version and someone else a 1.06.04 then there will be issues because one uses a serial value to determine the next id's and once reserves blocks of values.

If you have issues try creating a new DB and then make sure both are update to a recent build. Moving forward it shouldn't make much difference since this method will not be changing.

Roy

ffrllc
11-04-2008, 12:20 PM
Whoa !!!

So if this is possible, can I have my office desktop and my home laptop (that are in different locations and not networked together) work off the same HM DB?

If so, how would I go about doing this?

morny
11-04-2008, 12:28 PM
This might help http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=161 but to be honest ive not tried it

Also see this one http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=154

consideratio
10-15-2010, 11:22 PM
Dead links above, what were they about?

morny
10-15-2010, 11:58 PM
These are the links
FAQ - Hold'em Manager Poker Tracking Software :: Run PostgreSQL Over a Network (http://faq.holdemmanager.com/questions/90/Run+PostgreSQL+Over+a+Network+)

FAQ - Hold'em Manager Poker Tracking Software :: How do I setup Holdem Manager to share one database between two computers? (http://faq.holdemmanager.com/questions/336/How+do+I+setup+Holdem+Manager+to+share+one+databas e+between+two+computers%3F)