Обсуждение: Limiting postmaster to listen in a particular ip address only

Hi,

I have two NICs in my machine i want that postmaster shud only listen to the
internal NIC . I cannot limit it to listen in  unix domain sockets only
because
it needs to be accessed from other machine inside LAN.

Is there any way to accomplish it or a restrictive pg_hba.conf is the only
solution ?

Most of the servers ( like bind,apache) provide the facitly  of accepting
connections only on particular ip addresses / interfaces shud postmaster
also provide the same (in case its not so)?

Regds
mallah.

--

regds
Mallah.

Rajesh Kumar Mallah
+---------------------------------------------------+
| Tradeindia.com  (3,11,246) Registered Users         |
| Indias' Leading B2B eMarketPlace                  |
| http://www.tradeindia.com/                |
+---------------------------------------------------+

Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> I have two NICs in my machine i want that postmaster shud only listen to the
> internal NIC .

See virtual_host (or listen_addresses in 8.0).

            regards, tom lane

On Tue, Oct 26, 2004 at 08:48:38PM +0530, Rajesh Kumar Mallah wrote:
>
> I have two NICs in my machine i want that postmaster shud only listen to the
> internal NIC . I cannot limit it to listen in  unix domain sockets only
> because it needs to be accessed from other machine inside LAN.

In PostgreSQL 7.4 and earlier, set the virtual_host configuration
variable in postgresql.conf.  In 8.0 (currently in beta), use
listen_addresses.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/