PDA

View Full Version : Sharing a PostgreSQL 8.4 Database Over A Home Network?



thebenCA
12-05-2010, 09:40 PM
I'm running HEM w/ PostgreSQL 8.4 on my desktop and want to run HEM off the same database on my laptop by sharing it over my local area network. I found a link on the HEM website walking me how to do it on version 8.3. Does anyone know how to do this with PostgreSQL v.8.4?

netsrak
12-06-2010, 04:45 AM
Its the same in 8.4 FAQ - Hold'em Manager Poker Tracking Software :: Run PostgreSQL Over a Network (http://faq.holdemmanager.com/questions/90/Run+PostgreSQL+Over+a+Network+)

But i recommend to edit the pg_hba.conf file directly and not use the pgadmin interface.

scoobediah
03-30-2011, 07:45 PM
Where exactly do I put this line, "host all all 192.168.1.103 md5" in the pg_hba file? I'm trying to connect my laptop to my main database through my home network.

Patvs
03-30-2011, 08:12 PM
# 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
host all all 192.168.1.103 md5