View Full Version : How to share a database
darkrem
02-14-2009, 04:33 AM
Hi there, i've got a new laptop today that i plan to use to play at school :D
However i don't see myself carrying my external drive there. Is there anyway that i could merge the two databases easily so i could to it quite often?
Thanks for ur advice
Pokernils
02-14-2009, 07:08 AM
This works fine for me :)
http://http://www.holdemmanager.net/faq/afmmain.aspx?faqid=154
EDIT: Ohh, you dont want to carry the HD, sry. Then I have no idea. But have you checked out WD MY Passport, it`s soooo small. http://www.westerndigital.com/en/products/products.asp?DriveID=391
Bloged
02-14-2009, 10:09 AM
It is possible to share your database at home via network/internet if you want. That way HM can connect from everywhere you want to!
Grtz, Bloged
myth123
02-15-2009, 03:09 AM
It is possible to share your database at home via network/internet if you want. That way HM can connect from everywhere you want to!
Grtz, Bloged
Have you tried this over the internet to see how fast it is?
udbrky
02-15-2009, 04:02 AM
Step 1: Install PG and HEM on base comp. Choose to have it listen to all addresses. Create DB.
Step 2: Edit .config file so it says all this at the bottom:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 192.168.1.0/24 trust
# IPv6 local connections:
host all all ::1/128 trust
host all all 192.168.0.0/24 trust
host all all 192.168.0.0 trust
host all all 192.168.0.1 trust
host all all 192.168.0.2 trust
host all all 192.168.0.3 trust
host all all 192.168.1.0/24 trust
host all all 192.168.1.1 255.255.255.255 trust
host all all 192.168.1.100 trust
These 192.168.x addresses are for your network. I don't think you need all these, but it's working for me, so I'm not changing it.
I usually copy this file and paste it onto the remote computer as well, over the config file there. (pg_hba.conf)
Step 3: Install on other computer.
Step 4: Make sure they're accessible to each other in your network.
Step 5: Make sure your firewall trusts the IP range your other computers will be using to access the DB.
Open HEM on remote computer, point to the IP address on DB computer, find the database, set as default.
????
Profit.
Now, can someone tell me how to get postgres going on vista?
DK115
02-15-2009, 04:28 AM
Paul Morny,
Mailed you a faq with complete details and screenshot how to achieve this. Where is it?
myth123
02-15-2009, 06:39 AM
Truth be told you could probably use an iPod as an external HD and has plenty of room left over.
morny
02-15-2009, 08:14 PM
Hi Daan,
Yeah forgot about this, had it in my to list but forgot about it, ill get it up tommorrow or the next day
Raakande
06-30-2009, 01:43 PM
Step 1: Install PG and HEM on base comp. Choose to have it listen to all addresses. Create DB.
Step 2: Edit .config file so it says all this at the bottom:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 192.168.1.0/24 trust
# IPv6 local connections:
host all all ::1/128 trust
host all all 192.168.0.0/24 trust
host all all 192.168.0.0 trust
host all all 192.168.0.1 trust
host all all 192.168.0.2 trust
host all all 192.168.0.3 trust
host all all 192.168.1.0/24 trust
host all all 192.168.1.1 255.255.255.255 trust
host all all 192.168.1.100 trust
These 192.168.x addresses are for your network. I don't think you need all these, but it's working for me, so I'm not changing it.
I usually copy this file and paste it onto the remote computer as well, over the config file there. (pg_hba.conf)
Step 3: Install on other computer.
Step 4: Make sure they're accessible to each other in your network.
Step 5: Make sure your firewall trusts the IP range your other computers will be using to access the DB.
Open HEM on remote computer, point to the IP address on DB computer, find the database, set as default.
????
Profit.
Now, can someone tell me how to get postgres going on vista?
Does this work if the base computer behind a router? Or if you are behind a router with a laptop?
netsrak
06-30-2009, 02:41 PM
If you can ping the computer and can connect via pgadmin it will work
Ivanovich
11-28-2009, 12:55 PM
Can a procedure for how to do this be added to the FAQ?
What has been described in this thread so far leads me to believe it's possible to do it, but the information is not complete enough for a non-PC expert to attempt it.
Please help!
Thanks.
fozzy71
11-28-2009, 03:06 PM
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=154
Ivanovich
11-29-2009, 12:53 PM
Thanks for the reply fozzy but that's not what I'm trying to do.
I don't want to drag an external HDD around. I just want to share the database or make it accessible over my home network so I can run HEM on my notebook while maintaining the database on the desktop.
My desktop is set to use HDCP, so I don't know if that means it doesn't have a static IP and therefore will not work???
fozzy71
11-29-2009, 01:43 PM
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=184
Ivanovich
11-29-2009, 04:12 PM
yep, I did find that one.
I don't know how to determine the IP of my computer. I tried whatismyipaddress.com and got an IP, but it appears to be the router.
I have Verizon FIOS and my TCP/IP settings are set up as "DHCP Enabled"
Is that game over?
Ivanovich
11-29-2009, 04:51 PM
I found the IP on my LAN properties.
Now I get this!
http://mysite.verizon.net/irnavarro/HEMError.JPG
Ivanovich
11-29-2009, 05:09 PM
and this:
http://mysite.verizon.net/irnavarro/HEMError2.JPG
fozzy71
11-29-2009, 05:25 PM
I am lost when it comes to networking. I will forward the thread to my colleagues to see if they can assist you.
Ivanovich
11-29-2009, 05:30 PM
Cool. I thinnk the network is working now, since I am receiving messages back. I think it's something in the postgres setup. I'm not sure the edits to the .conf files are being read in.
The above shown .conf file talks about resetting some postmaster or something, but doesn't explain how.
I stopped and restarted the service, but I'm not sure it's enough. Restarting PC didn't make a difference either.
I feel like I'm getting closer!
So of course now my wife has commandeered the PC and kicked me off! :-(
fozzy71
11-30-2009, 09:46 PM
A reply from a co-worker.
first error should be fixed by postgres restart but it indicates a problem with firewall imo. 2nd = he probably has a typo in his pg_hba file
George Jackson
12-07-2009, 03:30 AM
Cool. I thinnk the network is working now, since I am receiving messages back. I think it's something in the postgres setup. I'm not sure the edits to the .conf files are being read in.
The above shown .conf file talks about resetting some postmaster or something, but doesn't explain how.
I stopped and restarted the service, but I'm not sure it's enough. Restarting PC didn't make a difference either.
I feel like I'm getting closer!
So of course now my wife has commandeered the PC and kicked me off! :-(
did you ever get the dbs networked ??? i want to do the same thing, so, i am interested. i know i cant do it myself though. if i try to do it myself, nothing will work.
George Jackson
12-07-2009, 03:31 AM
Hi there, i've got a new laptop today that i plan to use to play at school :D
However i don't see myself carrying my external drive there. Is there anyway that i could merge the two databases easily so i could to it quite often?
Thanks for ur advice
did you ever get your dbs networked ??
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.