Alexander Yeliseyev wrote: > > The following bug has been logged online: > > Bug reference: 2186 > Logged by: Alexander Yeliseyev > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.2 > Operating system: SuSe Linux 9.2 > Description: syntax error in postgresql.conf > Details: > > [EMAIL PROTECTED]:~> ./pgSQL.boot > [EMAIL PROTECTED]:~> cat server.log > FATAL: syntax error in file "/Data/postgresql.conf" line 48, near token > "," > [EMAIL PROTECTED]:~> > > 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
