Nick Na

logging_collector = on #打开日志 log_directory = 'pg_log' #日志目录# 每天生成一个新的日志文件 log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' log_truncate_on_rotation = off log_rataion_age = 1d log_ratation_size =

SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='db' AND pid<>pg_backend_pid();