Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 20BF09FB31E for ; Mon, 28 May 2007 08:02:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 51439-02 for ; Mon, 28 May 2007 08:01:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id E1F1C9FB2BB for ; Mon, 28 May 2007 08:01:55 -0300 (ADT) Received: (qmail 25486 invoked from network); 28 May 2007 11:01:52 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;823f6f480061ac61fdcf22dac09a32b3; Received: from mail.weatherbeeta.com.au (10.10.0.2) by network-box.weatherbeeta.com.au with SMTP; 28 May 2007 11:01:52 -0000 Received: (qmail 1532 invoked by uid 1166); 28 May 2007 21:01:43 +1000 Received: from 203.214.38.76 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:0(203.214.38.76):. Processed in 0.261105 secs); 28 May 2007 11:01:43 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:0(203.214.38.76):. Processed in 0.261105 secs Process 1523) Received: from 203-214-38-76.dyn.iinet.net.au (HELO ?192.168.1.253?) (phillip.smith@weatherbeeta.com.au@203.214.38.76) by mail.weatherbeeta.com.au with SMTP; 28 May 2007 21:01:42 +1000 Subject: Re: Syntax in postgresql.conf From: Phillip Smith Reply-To: phillip.smith@weatherbeeta.com.au To: Johann Spies Cc: pgsql-admin@postgresql.org In-Reply-To: <20070528091132.GA32403@sun.ac.za> References: <20070528091132.GA32403@sun.ac.za> Content-Type: multipart/alternative; boundary="=-f4TTp/OHzATSSpGem4lZ" Organization: Weatherbeeta P/L Date: Mon, 28 May 2007 21:05:37 +1000 Message-Id: <1180350337.4703.42.camel@fukawi2.homelinux.net> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1180350112.480-25481-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.03/0.10 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/288 X-Sequence-Number: 25608 --=-f4TTp/OHzATSSpGem4lZ Content-Type: text/plain Content-Transfer-Encoding: 7bit I believe you would need it to be: listen_addresses = '192.168.0.1,localhost' ie, Don't close the quotes between your CSV's On Mon, 2007-05-28 at 11:11 +0200, Johann Spies wrote: > 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? *******************Confidentiality and Privilege Notice******************* The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments --=-f4TTp/OHzATSSpGem4lZ Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit I believe you would need it to be:
    listen_addresses = '192.168.0.1,localhost'

ie, Don't close the quotes between your CSV's

On Mon, 2007-05-28 at 11:11 +0200, Johann Spies wrote:
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?

*******************Confidentiality and Privilege Notice*******************

The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email.

Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments
--=-f4TTp/OHzATSSpGem4lZ--