配置
log_destination = 'csvlog'
logging_collector = off
log_directory = 'pg_log'
log_connections = on
log_disconnections = on
log_line_prefix = '%t [%p-%l] %q%u@%d '
sql⽅式
alter role postgres set log_statement = 'none'; //postgres⽤户下所有数据库
alter role postgres in database my_db set log_statement='none';//postgres⽤户下某⼀个数据库
查看
select * from pg_db_role_setting ;
setdatabase | setrole | setconfig
-------------+---------+---------------------
27602 | 10 | {log_statement=none}
0 | 10 | {log_statement=none}
(2 rows)
setdatabase 0 为全部数据库
select a.*,b.lname from pg_db_role_setting a,pg_database b,pg_roles c where a.setdatabase=b.oid and a.setrole=c.oid; setdatabase | setrole | setconfig | datname | rolname
-------------+---------+---------------------+----------+----------
27602 | 10 | {log_statement=ddl} | new_test | postgres
日志审计
(1 row)