On Friday 30 November 2007 2:31 am, Andrus wrote: > > That works fine for me... are you sure log_line_prefix is line 482 in > > your config file? You might have inadvertently put a superfluous % > > somewhere else. > > 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 ? > > Andrus. > > > # - What to Log - > log_line_prefix = '%t ' # Special values: > #-------------------------------------------------------------------------- >- # CUSTOMIZED OPTIONS > #-------------------------------------------------------------------------- >- > > #custom_variable_classes = '' # list of custom variable class names > > listen_addresses = '*' > log_destination = 'stderr' > redirect_stderr = on > stats_start_collector = on > stats_row_level = on > autovacuum = on > shared_buffers= 15000 # kui on 1 GB opmälu > > log_min_duration_statement = 20000 # millisekundites, -1 on keelatud, 0 > logib kõik > #log_line_prefix='%t %u %d %h %p %i %l %x ' > You have log_line_prefix in two locations, under What to log and CUSTOMIZED OPTIONS. I would suggest keeping it under What to log. -- Adrian Klaver aklaver@xxxxxxxxxxx ---------------------------(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