Re: [GENERAL] log_line_prefix='%t %u %d %h %p %i %l %x ' causes error

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@comcast.net

---------------------------(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