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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-01-19 21:37:27 | Re: BUG #2180: log_statement=mod does not work |
Previous Message | Bruce Momjian | 2006-01-19 21:12:53 | Re: BUG #2184: Insertion problem |