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

Alexander Yeliseyev wrote:
>
> The following bug has been logged online:
>
> Bug reference:      2186
> Logged by:          Alexander Yeliseyev
> Email address:      y575@yandex.ru
> PostgreSQL version: 8.1.2
> Operating system:   SuSe Linux 9.2
> Description:        syntax error in postgresql.conf
> Details:
>
> postgres@linux:~> ./pgSQL.boot
> postgres@linux:~> cat server.log
> FATAL:  syntax error in file "/Data/postgresql.conf" line 48, near token
> ","
> postgres@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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073