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
