Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 15ADF9FB2E0 for ; Mon, 28 May 2007 06:11:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 52450-05 for ; Mon, 28 May 2007 06:11:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail1.sun.ac.za (mail1.sun.ac.za [146.232.64.12]) by postgresql.org (Postfix) with ESMTP id BD2389FB2D0 for ; Mon, 28 May 2007 06:11:39 -0300 (ADT) Received: from burger.sun.ac.za ([146.232.128.30]) by mail1.sun.ac.za with esmtp (Exim 4.50) id 1HsbGH-00006K-2d for pgsql-admin@postgresql.org; Mon, 28 May 2007 11:11:33 +0200 Received: from js by burger.sun.ac.za with local (Exim 4.63) (envelope-from ) id 1HsbGH-0008RJ-0C for pgsql-admin@postgresql.org; Mon, 28 May 2007 11:11:33 +0200 Date: Mon, 28 May 2007 11:11:32 +0200 From: Johann Spies To: pgsql-admin@postgresql.org Subject: Syntax in postgresql.conf Message-ID: <20070528091132.GA32403@sun.ac.za> Mail-Followup-To: Johann Spies , pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.197 tagged_above=0 required=5 tests=AWL=0.196, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200705/287 X-Sequence-Number: 25607 A comment in postgresql.conf on Debian says: " # comma-separated list of addresses; # defaults to 'localhost', '*' = all " But when I try listen_addresses = '192.168.0.1', 'localhost' I get $sudo /etc/init.d/postgresql-8.1 restart * Restarting PostgreSQL 8.1 database server * Error: Invalid line 53 in /etc/postgresql/8.1/main/postgresql.conf Why? Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch "Wait on the LORD; be of good courage, and he shall strengthen thine heart; wait, I say, on the LORD." Psalms 27:14