如何在 PostgreSQL 中查看过去的 SQL 语句执行记录
最编程
2024-07-24 13:45:30
...
默认是没有日志记录的,需要做如下调整:
1,修改配置文件,postgres.conf # 该文件在你的data 文件夹下,比如我的:/var/lib/postgresql/data/
调整的参数:
修改前注意备份postgres.conf
log_statement = 'all' # This is used when logging to stderr: logging_collector = on # Enable capturing of stderr and csvlog # into log files. Required to be on for # csvlogs. # (change requires restart) # These are only used if logging_collector is on: log_directory = '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_file_mode = 0600 # creation mode for log files, # begin with 0 to use octal notation #log_truncate_on_rotation = off # If on, an existing log file with 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 disables. #log_rotation_size = 10MB # Automatic rotation of logfiles will # happen after that much log output. # 0 disables.
2, 重启posgres 服务,
3,在该路径下查看你的日志文件:
/var/lib/postgresql/data/log
ps: 该postgres服务是使用dockers搭建的.
原文地址:https://www.cnblogs.com/qianxunman/p/12149586.html