BUG #2186: syntax error in postgresql.conf

Started by Alexander Yeliseyevover 20 years ago2 messagesbugs
Jump to latest
#1Alexander Yeliseyev
y575@yandex.ru

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.

#2Bruce Momjian
bruce@momjian.us
In reply to: Alexander Yeliseyev (#1)
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