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

BUG #2186: syntax error in postgresql.conf

From: "Alexander Yeliseyev" <y575(at)yandex(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2186: syntax error in postgresql.conf
Date: 2006-01-19 16:26:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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

postgres(at)linux:~> ./pgSQL.boot
postgres(at)linux:~> cat server.log
FATAL:  syntax error in file "/Data/postgresql.conf" line 48, near token

the line 48 in postgresql.conf is:
listen_addresses = 'eth0','localhost'
                                        # what IP address(es) to listen on;
                                        # comma-separated list of
                                        # defaults to 'localhost', '*' =

I can not understand, and it is not clear written in documentation, what is
the right syntax to configure PgSQL to listen connections from 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.


pgsql-bugs by date

Next:From: Tom LaneDate: 2006-01-19 17:14:41
Subject: Re: Huge number of disk writes after migration to 8.1
Previous:From: Magnus HaganderDate: 2006-01-19 16:04:28
Subject: Re: Huge number of disk writes after migration to 8.1

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