Thread: Can't connect from computer on network.

Hi.

I think setting Listen_address to *, does not necessary allows all connections but allows your PostgreSQL server to support TCP/IP connections. So, leave it as it is.

In order to apply control over what machine IP addresses should connect remotely to your server; specify the IP addresses in the pg_hba.conf file.

e.g

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

 Host     <DBname>    DKing        192.168.2.102                 <Specifies user Authentication>

Make sure you restart your PostgreSQL serve after performing the above.

Hope this helps.

Makgati.

Hi list,

I am using postgresql 8.2 on Ubuntu Gutsy. I am attempting to connect to my database on one computer from another computer on my network. I can connect to the database if I have:

listen_addresses = '*'

in my postgresql.conf file. But I can't connect if I have:

listen_addresses = 'localhost, 192.168.2.102'

in my postgresql.conf file. The computer that is assigned 192.168.2.102 is the computer I am attempting to connect from that works with the * but not with an assigned IP address. I understand that having a * allows all connections but I am attempting to restrict this so only a certain computer can access the database.

Does anyone know why I can't connect to the database from another computer when specifying the IP address in 'listen_addresses' and how to fix my problem?

Thanks a lot for the help.

Dan

Nalini, your quiet correct that, listen_addresses = * , implies that your server must listen on all network interfaces. Dan does not have an issue with his server listening on all network interfaces. His issue is to restrict the client machines that connect to his server.

Now, he is trying to achieve the above by changing the listen_address configuration parameter and I am saying he must leave it as it is (*) and then modify his pg_hba.conf file (as stated in the previous e-mail).

In case he wants to specify that his server must listen on a specific ip address (say – 201.111.223.222)

Then he must set listen_address = 201.111.223.222 in the postgresql configuration file.

Dan, Do not forget to restart you server after performing any of the above tasks

* in postgresql.conf actually denotes the network interfaces on the machine on which the postgresql server is running.

If you wish to limit access to certain IPs do it in pg_hba.conf.


----- Original Message -----
From: "Mehlape, Makgati" <MMehlape1@fnb.co.za>
Date: Tuesday, February 19, 2008 3:12 pm
Subject: Re: [ADMIN] Can't connect from computer on network.
To: Dan King <danking12@gmail.com>, pgsql-admin@postgresql.org

>

>
>
>
>
>
>
>
>
>
>
>
>

>
>

>
>
>
>

To read FirstRand
> Bank's Disclaimer for this email click on the following address or copy into
> your Internet browser:
> https://www.fnb.co.za/disclaimer.html
>

>

If you are unable to
> access the Disclaimer, send a blank e-mail to firstrandbankdisclaimer@fnb.co.za
> and we will send you a copy of the Disclaimer.

>

>
>
>
>

Nalini S. Nautiyal
System Software Division
NIC HQ
New Delhi
Ph 24360324,24305121,24305131