Group: pgsql.general


Subject: log_line_prefix='%t %u %d %h %p %i %l %x ' causes error
From: Andrus
Date: 11/29/2007 12:59:56 PM
I added the following line to postgresql.conf file: log_line_prefix='%t %u %d %h %p %i %l %x ' but got error. 2007-11-29 12:40:41 LOG: syntax error in file "D:/Program Files/PostgreSQL/8.2/data/postgresql.conf" line 482, near token "%" I checked and all options are legal. What I'm doing wrong ? Why error message does not show exact information about error ? Andrus.

Subject: log_line_prefix='%t %u %d %h %p %i %l %x ' causes error
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 12/2/2007 6:02:47 PM
"Andrus" <kobruleht2@hot.ee> writes: > I use the config file below. I have added only some lines to the end of > file, all other contents is from windows installer created conf file. > If I remove # sign in front of last line (line 482), and reload > configuration, I got syntax error > in log file. > Is this Postgres bug ? I still can't duplicate that --- the only way I can get that error is to leave out the first ' mark. What PG version are you using? Back in 8.0 there used to be some odd corner cases if the last line didn't end with a newline character, though AFAIR that still wouldn't produce exactly this symptom. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq