X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A2B7F3A4461 for ; Tue, 26 Oct 2004 17:32:41 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33911-01 for ; Tue, 26 Oct 2004 16:32:39 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 964D53A444E for ; Tue, 26 Oct 2004 17:32:36 +0100 (BST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id i9QGWW2u001138 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Tue, 26 Oct 2004 10:32:35 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id i9QGWWZ4098679; Tue, 26 Oct 2004 10:32:32 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id i9QGWWGk098678; Tue, 26 Oct 2004 10:32:32 -0600 (MDT) (envelope-from mfuhr) Date: Tue, 26 Oct 2004 10:32:32 -0600 From: Michael Fuhr To: Rajesh Kumar Mallah Cc: Postgres Admin List Subject: Re: Limiting postmaster to listen in a particular ip address only Message-ID: <20041026163232.GA98536@winnie.fuhr.org> References: <417E6ACE.3020204@trade-india.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <417E6ACE.3020204@trade-india.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/350 X-Sequence-Number: 15343 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/