Limiting postmaster to listen in a particular ip address only

[Rajesh Kumar Mallah]

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/ |
+---------------------------------------------------+


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Tom Lane]

Post by Rajesh Kumar Mallah
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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Michael Fuhr]

Post by Rajesh Kumar Mallah
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.