reading databases from networked computer?

[WhiteRider]

Make sure the line that defines that address doesn't have a # symbol at the start as that comments out the line (i.e. doesn't use it).

[mjr161]

Nope, they're def not commented out, at least not on the new lines that I added. I don't have Postgres installed at all on the playing computer where pt3 is. The playing computer IP is 192.168.1.8 and the db computer is 192.168.1.6. The db server is Mac OSX Leopard Server and the playing computer is Mac OSX Leopard with a WinXP VM.


Here are the last few lines of each file.

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all md5
# 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.0/24 md5





#------------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#------------------------------------------------------------------------------

#custom_variable_classes = '' # list of custom variable class names
listen_addresses = '*'

[kraada]

Try changing md5 to trust and see if that fixes things for you; that will remove the need to authenticate via password for any machine on your local network and might allow for an easier connection.

[mjr161]

I think I figured it out. I had to use the PGAdmin tool to edit the hba doc, when I was doing it with the text editor it was screwing it up.

Thanks so much for the help.

[mjr161]

I just wanted to add that for anyone that has the resources/know how to do so, networking the db to a small server/unused computer is a great idea. I have a playing db with about 400k hands in it as well as a datamine db with 3mil+hands that my hud pulls from. My playing machine really lagged when I would have a bunch of tables and different sites open, even though my playing computer is a beefy quad core Xeon MacPro with 5gb of ram.

Not having your playing computer doing double time as a database server really takes a ton of stress off the machine, and pt3 runs extremely smooth without that burden.