PDA

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 ??