Re: Can't connect from computer on network. - Mailing list pgsql-admin
| From | Mehlape, Makgati |
|---|---|
| Subject | Re: Can't connect from computer on network. |
| Date | |
| Msg-id | 6A4EAA8FBBA19B4D840721B7A2419D4F44D179D3@fnbcolmx01.fnb.co.za Whole thread Raw |
| In response to | Re: Can't connect from computer on network. (nalini <nalini@nic.in>) |
| List | pgsql-admin |
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@nic.in [mailto:nalini@nic.in]
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. Hi. I think setting Listen_address to *, does In order to apply control over what e.g # TYPE DATABASE USER Host <DBname> DKing Make sure you restart your PostgreSQL Hope this helps. Makgati. From: Hi list,
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
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> not necessary allows all connections but allows your PostgreSQL server to
> support TCP/IP connections. So, leave it as it is.
>
>
>
>
> machine IP addresses should connect remotely to your server; specify the IP
> addresses in the pg_hba.conf file.
>
>
>
>
>
>
>
>
> CIDR-ADDRESS METHOD
>
>
>
>
> 192.168.2.102 <Specifies user Authentication>
>
>
>
>
> serve after performing the above.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] 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.
>
>
>
>
>
>
>
>
>
> 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 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@fnb.co.za and we will send you a copy of the Disclaimer.
pgsql-admin by date: