richlizard
11-03-2009, 04:57 PM
Please excuse me for posting yet another thread on using Postgres across a network.
I know there have been numerous threads and have read just about all of them. Unfortunately, none of them seem to work for me so I hope someone may be able to help out with my specific problem.
Although I have allowed access through port 5432, I have tried most things with firewall off, so please assume it is not a firewall problem.
I have a PC where I have installed HEM (1.09 on Vista) and also Postgresql (8.3).
I have a laptop where I have installed just HEM (1.09 on Vista).
I had to set up Postgresql on PC using postgresuser as the username as it would not accept postgres (as advised on the pages here).
IP for the PC is 192.168.2.3
IP for the laptop is 192.168.2.2
IP for the router is 192.168.2.1
I have modified the pg_hba.conf file on the PC (stolen and adjusted from a thread here) so that it reads
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 192.168.2.0/24 trust
# IPv6 local connections:
host all all ::1/128 trust
host all all 192.168.2.0/24 trust
host all all 192.168.2.0 trust
host all all 192.168.2.1 trust
host all all 192.168.2.2 trust
host all all 192.168.2.3 trust
host all all 192.168.2.0/24 trust
host all all 192.168.1.1 255.255.255.255 trust
host all all 192.168.1.100 trust
# IPv6 local connections:
host all all ::1/128 md5
So now to the laptop...
I start up HEM and am first given the mssg that it cannot connect to 127.0.0.1 of course. So I change 127.0.0.1 to 192.168.2.3 and am given the error message "A connection to PostgreSQL could not be made. Would you like... etc.,". Accepting the kind offer, it still refuses to connect.
So I then remember that I had to use login name postgresuser so I change to that. Exactly the same procedure occurs.
As I mentioned, this also happens with firewall off. I can ping 192.168.2.3 without a problem.
Is there something blatantly obvious I am doing wrong?
I have spent 2 days now trawling the forum for a solution and uninstalling/reinstalling the software but no joy.
Would very much appreciate any help.
I know there have been numerous threads and have read just about all of them. Unfortunately, none of them seem to work for me so I hope someone may be able to help out with my specific problem.
Although I have allowed access through port 5432, I have tried most things with firewall off, so please assume it is not a firewall problem.
I have a PC where I have installed HEM (1.09 on Vista) and also Postgresql (8.3).
I have a laptop where I have installed just HEM (1.09 on Vista).
I had to set up Postgresql on PC using postgresuser as the username as it would not accept postgres (as advised on the pages here).
IP for the PC is 192.168.2.3
IP for the laptop is 192.168.2.2
IP for the router is 192.168.2.1
I have modified the pg_hba.conf file on the PC (stolen and adjusted from a thread here) so that it reads
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 192.168.2.0/24 trust
# IPv6 local connections:
host all all ::1/128 trust
host all all 192.168.2.0/24 trust
host all all 192.168.2.0 trust
host all all 192.168.2.1 trust
host all all 192.168.2.2 trust
host all all 192.168.2.3 trust
host all all 192.168.2.0/24 trust
host all all 192.168.1.1 255.255.255.255 trust
host all all 192.168.1.100 trust
# IPv6 local connections:
host all all ::1/128 md5
So now to the laptop...
I start up HEM and am first given the mssg that it cannot connect to 127.0.0.1 of course. So I change 127.0.0.1 to 192.168.2.3 and am given the error message "A connection to PostgreSQL could not be made. Would you like... etc.,". Accepting the kind offer, it still refuses to connect.
So I then remember that I had to use login name postgresuser so I change to that. Exactly the same procedure occurs.
As I mentioned, this also happens with firewall off. I can ping 192.168.2.3 without a problem.
Is there something blatantly obvious I am doing wrong?
I have spent 2 days now trawling the forum for a solution and uninstalling/reinstalling the software but no joy.
Would very much appreciate any help.