Euler, fiz algumas combinações, inclusive esta que voce sugeriu (juro que o manual antes) e repeti agora. Veja a minha configuração no postgresql.conf:
... logging_collector = on ... log_directory = '/linux_02/pgsql/slog1/dmonitor/' ... log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' ... # - When to Log - ... client_min_messages = warning ... log_min_messages = debug5 ... #log_error_verbosity = default ... #log_min_error_statement = error ... #log_min_duration_statement = -1 ... #silent_mode = off ... # - What to Log - ... #debug_print_parse = off #debug_print_rewritten = off #debug_print_plan = off #debug_pretty_print = on ... log_checkpoints = on log_connections = on log_disconnections = on log_duration = on log_hostname = on log_line_prefix = '[%u][%d][%p][%m][%i][%c][%l][%s][%v][%x]\n' ... log_lock_waits = off log_statement = 'all' log_temp_files = 0 ... #log_timezone = unknown ... Reiniciei o servidor: pg_ctl stop e no pg_ctl start, o susto : .... [][][10204][2009-07-04 19:22:48.427 GMT][][4a4fac07.27dc][547][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Antarctica/South_Pole" scores 0: at 1231977600 2009-01-15 13:00:00 dst versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.427 GMT][][4a4fac07.27dc][548][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Antarctica/McMurdo" scores 0: at 1231977600 2009-01-15 13:00:00 dst versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.427 GMT][][4a4fac07.27dc][549][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Antarctica/Palmer" scores 0: at 1231977600 2009-01-14 21:00:00 dst versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.427 GMT][][4a4fac07.27dc][550][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Antarctica/Mawson" scores 0: at 1231977600 2009-01-15 06:00:00 std versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.428 GMT][][4a4fac07.27dc][551][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Antarctica/Vostok" scores 0: at 1231977600 2009-01-15 06:00:00 std versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.428 GMT][][4a4fac07.27dc][552][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Africa/Cairo" scores 0: at 1231977600 2009-01-15 02:00:00 std versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.428 GMT][][4a4fac07.27dc][553][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Africa/Tripoli" scores 0: at 1231977600 2009-01-15 02:00:00 std versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.428 GMT][][4a4fac07.27dc][554][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Africa/Niamey" scores 0: at 1231977600 2009-01-15 01:00:00 std versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.429 GMT][][4a4fac07.27dc][555][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Africa/Porto-Novo" scores 0: at 1231977600 2009-01-15 01:00:00 std versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.430 GMT][][4a4fac07.27dc][556][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Africa/Kampala" scores 0: at 1231977600 2009-01-15 03:00:00 std versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.430 GMT][][4a4fac07.27dc][557][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Africa/Djibouti" scores 0: at 1231977600 2009-01-15 03:00:00 std versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.430 GMT][][4a4fac07.27dc][558][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Africa/Harare" scores 0: at 1231977600 2009-01-15 02:00:00 std versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.430 GMT][][4a4fac07.27dc][559][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Africa/Johannesburg" scores 0: at 1231977600 2009-01-15 02:00:00 std versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.431 GMT][][4a4fac07.27dc][560][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Africa/Ceuta" scores 0: at 1231977600 2009-01-15 01:00:00 std versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.431 GMT][][4a4fac07.27dc][561][2009-07-04 19:22:47 GMT][][0] DEPURAÇÃO: TZ "Africa/Monrovia" scores 0: at 1231977600 2009-01-15 00:00:00 std versus 2009-01-14 22:00:00 dst [][][10204][2009-07-04 19:22:48.431 GMT][][4a4fac07.27dc][562][2009-07-04 19:22:47 GMT][][0] ... Eu quero estas e todas as outras mensagens no arquivo e não tela. Tem como? Aproveitando, se voce puder fazer algum comentário sobre as variáveis de ambiente que postei num e-mail anterior, também lhe ficaria muito grato. Att., Sergio 2009/7/4 Euler Taveira de Oliveira <eu...@timbira.com> > sergio nogueira escreveu: > > como faço para ter no arquivo apontado em log_directory/log_filename um > > log debug5 mas, no prompt do psql, tenha apenas notice? > > > O que você procura é client_min_messages (cliente) e log_min_messages (log) > [1]. É necessário habilitar a coleta de logs (logging_collector) para > segunda > opção funcionar. > > [1] > > http://www.postgresql.org/docs/8.4/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN > > > -- > Euler Taveira de Oliveira > http://www.timbira.com/ > _______________________________________________ > pgbr-geral mailing list > pgbr-geral@listas.postgresql.org.br > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
