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
|