Обсуждение: 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/