Hi John
You are right about the router.
I now have PG Admin displaying the server. However it still won't connect
even with the firewall off.
Actually, the message says the the connection was 'actively' rejected.
I am not sure what you mean by this IP format 192.168.1.0/24.
I notice that the pg_hba file also includes an adress in similar format -
127.0.0.1/32.
How does this compare to my address 192.168.1.100?
Thanks in advance.
Bob
----- Original Message -----
From: "John R Pierce" <pie...@hogranch.com>
To: "PostgreSQL" <pgsql-general@postgresql.org>
Sent: Thursday, February 12, 2009 3:26 PM
Subject: Re: [GENERAL] Remote Connection
Bob Pawley wrote:
Hi
I've been operating on localhost successfully for some time.
I am now attempting to access a Postgresql 8.3 database installed on one
of my other computers conneted through a router.
Is this possible?
My first attempts have been with Postgresql Admin.
I changed host to the IP address of the computer and input the other
info.
I also ran - listen virtual; on the receiving server.
It hasn't connected successfully. I get the message 'Server not
listening'
presumably, when you say 'through a router', you mean, both client and
server systems are on the LAN side of the router, so its just a local
area network?
A) make sure LISTEN_ADDRESS is * and not localhost in postgresql.conf
B) if the server has a firewall make sure you allow inbound port 5432/tcp
C) make sure pg_hba.conf on the postgres server has a line similar to...
host all all 192.168.1.0/24 md5
where 192.168.1.* is the IP address of your local network. md5 says to
use password authentication.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
