Обсуждение: BUG #4773: Logging error

Поиск
Список
Период
Сортировка

BUG #4773: Logging error

От
"Arvind S"
Дата:
The following bug has been logged online:

Bug reference:      4773
Logged by:          Arvind S
Email address:      arvindwill@gmail.com
PostgreSQL version: 8.1
Operating system:   Cent OS
Description:        Logging error
Details:

I set log_min_duration_statement to 10000 and restart the postgres. But when
i check the tail to log i am getting all queries. please tell is it bug ?
i have log_statement = all . is there any relation between this and
min_duaration?

Re: BUG #4773: Logging error

От
Bruce Momjian
Дата:
Arvind S wrote:
>
> The following bug has been logged online:
>
> Bug reference:      4773
> Logged by:          Arvind S
> Email address:      arvindwill@gmail.com
> PostgreSQL version: 8.1
> Operating system:   Cent OS
> Description:        Logging error
> Details:
>
> I set log_min_duration_statement to 10000 and restart the postgres. But when
> i check the tail to log i am getting all queries. please tell is it bug ?
> i have log_statement = all . is there any relation between this and
> min_duaration?

The queries you are seeing are from log_statement = all.  The output of
log_min_duration_statement would be showing you times as well as
queries.  The two settings do not control each other.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +