Skip site navigation (1) Skip section navigation (2)

Re: BUG #2186: syntax error in postgresql.conf

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Alexander Yeliseyev <y575(at)yandex(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2186: syntax error in postgresql.conf
Date: 2006-01-19 21:24:37
Message-ID: 200601192124.k0JLOba21990@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Alexander Yeliseyev wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      2186
> Logged by:          Alexander Yeliseyev
> Email address:      y575(at)yandex(dot)ru
> PostgreSQL version: 8.1.2
> Operating system:   SuSe Linux 9.2
> Description:        syntax error in postgresql.conf
> Details: 
> 
> postgres(at)linux:~> ./pgSQL.boot
> postgres(at)linux:~> cat server.log
> FATAL:  syntax error in file "/Data/postgresql.conf" line 48, near token
> ","
> postgres(at)linux:~>     
> 
> the line 48 in postgresql.conf is:
> listen_addresses = 'eth0','localhost'
>                                         # what IP address(es) to listen on;
>                                         # comma-separated list of
> addresses;
>                                         # defaults to 'localhost', '*' =
> all
> 
> I can not understand, and it is not clear written in documentation, what is
> the right syntax to configure PgSQL to listen connections from
> 192.168.15.0/24 network only. It always returns error and does not starts
> up, just only writes this FATAL error in *.log file. And I have configured
> it to listen from 'eth0' and just have added 'localhost' after comma, I have
> received this error again.

Use 'eth0, localhost', meaning put the comma inside the quotes.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-01-19 21:37:27
Subject: Re: BUG #2180: log_statement=mod does not work
Previous:From: Bruce MomjianDate: 2006-01-19 21:12:53
Subject: Re: BUG #2184: Insertion problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group