From: | alberto <albertocardenasc190(at)gmail(dot)com> |
---|---|
To: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | log_statement no funciona |
Date: | 2025-04-25 13:45:25 |
Message-ID: | CAPZT8nXZOTcDvgpvXP9RXiEM9hmphKcOcCXqtCM3ZvFuzSYvzg@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Hola Lista, muy buenos días. Llevo varios días tratando de solucionar un
problema y es el siguiente:
Tengo la siguiente configuración para los log.
shared_preload_libraries = 'pgaudit'
log_destination = 'csvlog'
logging_collector = on
log_directory = 'log' # directory where log files are written,
log_file_mode = 0666
log_filename = 'server-%Y-%m-%d_%H%M%S.log'
log_rotation_age = 1d
log_rotation_size = 20MB
log_statement = 'none'
client_min_messages = error
log_min_messages = error
log_min_error_statement = error
log_min_duration_statement = 0
log_autovacuum_min_duration = 0
debug_print_parse = off
debug_print_rewritten = off
debug_print_plan = off
debug_pretty_print = off
log_lock_waits = off
log_temp_files = 0
log_checkpoints = off
log_connections = off
log_disconnections = off
log_duration = off
log_error_verbosity = default
log_hostname = off
###PGAUDIT
pgaudit.log ='ddl'
pgaudit.log_relation = off
pgaudit.log_catalog = off
pgaudit.log_client = off
pgaudit.log_level = log
pgaudit.log_parameter = off
pgaudit.log_statement = off
Como ven log_statement = 'none' está con el valor none, sin embargo en el
log de postgresql, siguen apareciendo los select y es precisamente lo que
no quiero que aparezcan. Alguien me puede dar una mano.
Saludos Cordiales
From | Date | Subject | |
---|---|---|---|
Next Message | Daymel Bonne Solís | 2025-04-25 16:28:39 | Re: log_statement no funciona |
Previous Message | Jairo Graterón | 2025-04-21 15:00:42 | Re: Posible fuga de memoria |