From: | Adrian Klaver <aklaver(at)comcast(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | "Andrus" <kobruleht2(at)hot(dot)ee> |
Subject: | Re: log_line_prefix='%t %u %d %h %p %i %l %x ' causes error |
Date: | 2007-12-02 22:38:14 |
Message-ID: | 200712021438.14516.aklaver@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)comcast(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2007-12-02 22:42:35 | Re: Linux v.s. Mac OS-X Performance |
Previous Message | Rainer Bauer | 2007-12-02 21:19:01 | Re: Cluster using tablespaces? |