Re: Remote Connection

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