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 556508BA120 for ; Mon, 14 Feb 2005 12:24:39 +0000 (GMT) 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 84229-02 for ; Mon, 14 Feb 2005 12:24:37 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.192]) by svr1.postgresql.org (Postfix) with ESMTP id 851A28BA119 for ; Mon, 14 Feb 2005 12:24:36 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 67so2121202wri for ; Mon, 14 Feb 2005 04:24:36 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=Cy4OKc/ckyEclpzgRauu1HHLJid7cIA6Wbiahz5SaNCjAsEdTE0Zg/zspdMxtupeS9poMWGxLssEkERTlMKiYQouq/TiyHWK6fH0DWFo78QJmwN4dfjl+DHJEnxskZNgZO2YnR2IR5sgyulYD2l9DRqv1Gl/ReTU6lpz9FlDG6s= Received: by 10.54.3.10 with SMTP id 10mr39712wrc; Mon, 14 Feb 2005 04:24:35 -0800 (PST) Received: by 10.54.57.52 with HTTP; Mon, 14 Feb 2005 04:24:35 -0800 (PST) Message-ID: <32c009ea050214042443b5cb84@mail.gmail.com> Date: Mon, 14 Feb 2005 14:24:35 +0200 From: "Milen A. Radev" Reply-To: milen@radev.net To: pgsql-admin@postgresql.org Subject: Problem binding postmaster to several interfaces Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/113 X-Sequence-Number: 16281 Hi everyone! I have postgresql 8.0.1 installed on a Slackware Linux machine. The machine is a multi-purpose device and it has external and internal interfaces. I would like to limit "postmaster" to listen only to the internal interface and the loopback. I tried to use the new "listen_addresses" directive but with no success so far. I tried several forms - I either got a syntax error, or the "postmaster" continued to listen to all interfaces - (0.0.0.0:5432 as shown by "netstat -tupan" command). Any ideas? The current value of my "listen_addresses" setting is: listen_addresses = '192.168.0.1, 127.0.0.1' but using "netstat -tupan" I still see: tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 10042/postmaster The contents of the logfile for the last reboot is: 2005-02-14 14:14:55.105721500 LOG: received smart shutdown request 2005-02-14 14:14:55.105728500 LOG: shutting down 2005-02-14 14:14:55.255392500 LOG: database system is shut down 2005-02-14 14:15:08.852971500 LOG: could not create IPv6 socket: Address family not supported by protocol 2005-02-14 14:15:08.880414500 LOG: database system was shut down at 2005-02-14 14:15:17 EET 2005-02-14 14:15:08.880987500 LOG: checkpoint record is at 0/DBA864 2005-02-14 14:15:08.881059500 LOG: redo record is at 0/DBA864; undo record is at 0/0; shutdown TRUE 2005-02-14 14:15:08.881112500 LOG: next transaction ID: 4243; next OID: 17395 2005-02-14 14:15:08.927491500 LOG: database system is ready The server was build with: ./configure --prefix=/usr/local/postgresql --with-openssl --with-python --with-php=/usr/src/php-4.3.10 --enable-nls The system is Slackware Linux 9.1.0 with kernel "Linux xxxxxxl 2.6.10 #1 Wed Feb 2 22:59:49 EET 2005 i686 unknown unknown GNU/Linux". -- Milen A. Radev