Pessoal, conseguir relsover.
Vlw a todos
________________________________
De: Osvaldo Kussama <[email protected]>
Para: Comunidade PostgreSQL Brasileira <[email protected]>
Enviadas: Sexta-feira, 15 de Maio de 2009 12:00:09
Assunto: Re: [pgbr-geral] log_min_duration_statement
2009/5/15 paulo matadr <[email protected]>:
> Pessoal , to com uma duvida
> eu to tentando abilitar o log_min_duration_statement para 2 min , assim
> pondo
> log_min_duration_statement = 120000
> e nao ta funcionando, existe a relaçao desse parametro com outro no
> postgresql.conf para que ele funcione;
> meu conf para logs abaixo:
> # - Where to Log -
>
> #log_destination = 'stderr' # Valid values are combinations of
> # stderr, syslog and eventlog,
> # depending on platform.
>
> # This is used when logging to stderr:
> redirect_stderr = on # Enable capturing of stderr into
> log
> # files
> # (change requires restart)
>
> # These are only used if redirect_stderr is on:
> #log_directory = 'pg_log' # Directory where log files are
> written
> # Can be absolute or relative to
> PGDATA
> #log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern.
> # Can include strftime() escapes
> #log_truncate_on_rotation = off # If on, any existing log file of the same
> # name as the new log file will be
> # truncated rather than appended to.
> But
> # such truncation only occurs on
> # time-driven rotation, not on
> restarts
> # or size-driven rotation. Default
> is
> # off, meaning append to existing
> files
> # in all cases.
> #log_rotation_age = 1d # Automatic rotation of logfiles
> will
> # happen after that time. 0 to
> # disable.
> #log_rotation_size = 10MB # Automatic rotation of logfiles
> will
> # happen after that much log
> # output. 0 to disable.
>
> # These are relevant when logging to syslog:
> #syslog_facility = 'LOCAL0'
> #syslog_ident = 'postgres'
>
>
> # - When to Log -
>
> #client_min_messages = notice # Values, in order of decreasing
> detail:
> # debug5
> # debug4
> # debug3
> # debug2
> # debug1
> # log
> # notice
> # warning
> # error
>
> #log_min_messages = notice # Values, in order of decreasing
> detail:
> # debug5
> # debug4
> # debug3
> # debug2
> # debug1
> # info
> # notice
> # warning
> # error
> # log
> # fatal
> # panic
>
> #log_error_verbosity = default # terse, default, or verbose
> messages
>
> #log_min_error_statement = error # Values in order of increasing
> severity:
> # debug5
> # debug4
> # debug3
> # debug2
> # debug1
> # info
> # notice
> # warning
> # error
> # fatal
> # panic (effectively off)
>
> log_min_duration_statement = 120000 # -1 is disabled, 0 logs all statements
> # and their durations.
>
> #silent_mode = off # DO NOT USE without syslog or
> # redirect_stderr
> # (change requires restart)
>
> # - What to Log -
>
> #debug_print_parse = off
> #debug_print_rewritten = off
> #debug_print_plan = off
> #debug_pretty_print = off
> #log_connections = off
> #log_disconnections = off
> #log_duration = off
> log_line_prefix = '%t [%p]: [%l-1]
> ' # Special values:
>
> # %u = user name
> #log_line_prefix = '%u %d %h %t %i' tava antes teste
> pgfouine # %d = database name
>
> # %r = remote host and port
>
> # %h = remote host
>
> # %p = PID
>
> # %t = timestamp (no milliseconds)
>
> # %m = timestamp with milliseconds
>
> # %i = command tag
>
> # %c = session id
>
> # %l = session line number
>
> # %s = session start timestamp
>
> # %x = transaction id
>
> # %q = stop here in non-session
>
> # processes
>
> # %% = '%'
>
> # e.g. '<%u%%%d> '
> log_statement =
> 'ddl' # none, ddl,
> mod, all
> #log_hostname = off
>
Repare que está especificado "log_statement = 'ddl' ". É isto mesmo?
Você está interessado apenas nos comandos ddl?
Osvaldo
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
