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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 11:57 AM To: Mehlape, Makgati Cc: Dan King; pgsql-admin@postgresql.org Subject: Re: [ADMIN] 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" <[EMAIL PROTECTED]> Date: Tuesday, February 19, 2008 3:12 pm Subject: Re: [ADMIN] Can't connect from computer on network. To: Dan King <[EMAIL PROTECTED]>, pgsql-admin@postgresql.org > > > > > > > > > > > > > > > > > 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: > [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan King > > Sent: Tuesday, February 19, 2008 > 11:27 AM > > To: pgsql-admin@postgresql.org > > Subject: [ADMIN] 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 <http://192.168.2.102> <http://192.168.2.102> > > <http://192.168.2.102> > > > > <http://192.168.2.102> 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 > <http://192.168.2.102> > <http://192.168.2.102> If you are unable to > access the Disclaimer, send a blank e-mail to [EMAIL PROTECTED] > and we will send you a copy of the Disclaimer. <http://192.168.2.102> > <http://192.168.2.102> > > > > Nalini S. Nautiyal System Software Division NIC HQ New Delhi Ph 24360324,24305121,24305131 <http://192.168.2.102> 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 [EMAIL PROTECTED] and we will send you a copy of the Disclaimer.
