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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
