pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Limiting postmaster to listen in a particular ip address only
3+ messages / 3 participants
[nested] [flat]

* Limiting postmaster to listen in a particular ip address only
@ 2004-10-26 15:18  Rajesh Kumar Mallah <mallah@trade-india.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Rajesh Kumar Mallah @ 2004-10-26 15:18 UTC (permalink / raw)
  To: pgsql-admin


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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Limiting postmaster to listen in a particular ip address only
@ 2004-10-26 16:27  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Rajesh Kumar Mallah <mallah@trade-india.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2004-10-26 16:27 UTC (permalink / raw)
  To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Limiting postmaster to listen in a particular ip address only
@ 2004-10-26 16:32  Michael Fuhr <mike@fuhr.org>
  parent: Rajesh Kumar Mallah <mallah@trade-india.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Michael Fuhr @ 2004-10-26 16:32 UTC (permalink / raw)
  To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: pgsql-admin

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/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-10-26 16:32 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-26 15:18 Limiting postmaster to listen in a particular ip address only Rajesh Kumar Mallah <mallah@trade-india.com>
2004-10-26 16:27 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-10-26 16:32 ` Michael Fuhr <mike@fuhr.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox