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

BUG #2186: syntax error in postgresql.conf

From
"Alexander Yeliseyev"
Date:
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.

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

From
Bruce Momjian
Date:
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