Re: Can't connect from computer on network.

["Mehlape, Makgati" <MMehlape1@xxxxxxxxx>]

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

 

---

From: nalini@xxxxxx [mailto:nalini@xxxxxx]
Sent: Tuesday, February 19, 2008 11:57 AM
To: Mehlape, Makgati
Cc: Dan King; pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: Can't connect from computer on network.

 

* 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@xxxxxxxxx>
Date: Tuesday, February 19, 2008 3:12 pm
Subject: Re: Can't connect from computer on network.
To: Dan King <danking12@xxxxxxxxx>, pgsql-admin@xxxxxxxxxxxxxx

>

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

>
>

>
>

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.

>
>

 

>
>

>
>

>
>

---

>
>

>
>

From:
> pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Dan King
>
> Sent: Tuesday, February 19, 2008
> 11:27 AM
>
> To: pgsql-admin@xxxxxxxxxxxxxx
>
> Subject: Can't connect
> from computer on network.

>
>

>
>

 

>
>

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

>
>

>
>
>
>

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@xxxxxxxxx
> and we will send you a copy of the Disclaimer.

>

 

>
>
>
>

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

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@xxxxxxxxx and we will send you a copy of the Disclaimer.