Re: Remote Connection
От | Bob Pawley |
---|---|
Тема | Re: Remote Connection |
Дата | |
Msg-id | 1509CCA47E344FE9915BF3A6E6ECC9C5@Bob обсуждение исходный текст |
Ответ на | Remote Connection ("Bob Pawley" <rjpawley@shaw.ca>) |
Ответы |
Re: Remote Connection
|
Список | pgsql-general |
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" <pierce@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
В списке pgsql-general по дате отправления: