Comments (3)
Thank you for reporting!
We can specify log level of audit log to the sever log by setting log_level
parameter in option
section, not level
parameter in output
section. Please try to set log_level = 'WARNING'
in option
section.
Also, pgaudit configuration parameters are always shown in LOG level, which is intentional, because these information is not audit information.
from pgaudit.
OK.
We confirmed that audit log is output as WARNING by setting log_level = 'WARNING' in option section.
- Config file
[output]
logger = 'serverlog'
[option]
log_level = 'WARNING'
role = 'auditor'
[rule]
format = '%t,%d,%u,%p,%v,%statement_id,%sub_statement_id,%class,%command_tag,%object_type,%object_name,%command_text'
class = 'READ,WRITE,DDL,ROLE,FUNCTION,MISC'
- Audit Log.
WARNING: AUDIT: SESSION,1,1,READ,2017-03-01 19:16:34 JST,postgres,postgres,[local],psql,2/3,0,,,SELECT,,,SELECT 1,<not logged>
from pgaudit.
Thank you for checking, close.
from pgaudit.
Related Issues (20)
- (refactored branch) Defining multiple output sections does not cause an error. HOT 3
- (refactored branch) Setting file error does not occur even if the order of each section is changed. HOT 7
- (refactored branch) When log_connections or log_disconnections is turned off and reloaded, connection audit logs are no longer output. HOT 4
- (refactore branch) Update Copyright
- (refactored branch) Even if an unnecessary token exists in the setting file, it does not cause an error. HOT 3
- (refactored branche) Question: Does the parameter name in the setting file allow only lowercase letters? HOT 3
- (refactored branche) When "log_parameter = on" is specified and SQL with multiple parameters is executed, parameters are concatenated. HOT 4
- (refactored branche) Parameters written in uppercase letters are ignored. HOT 3
- (refactored branch) There is a problem with the explanation of Session Audit Logging / Configuration of Readme.md. HOT 4
- (refactored branch) pid is not output to the audit log. HOT 5
- (refactored branch) The audit log that is output when pg_basebackup is executed is "class = SYSTEM" HOT 2
- (refactored branch) The filter by the database name has no effect on the audit log of the connection attempt. HOT 2
- (refactored branch) Even if you specify a command_tag filter, not filtered. HOT 2
- (refactored branch) Even if you specify a object_type filter, not filtered. HOT 3
- (refactored branch) Pattern matching with '%' character is not supported.
- (refactored branch) [bug] By config file description of mistakes, Segfault occurs during PostgreSQL start. HOT 3
- (refactored branch) Behavior when you specify an invalid timestamp literal HOT 4
- (refactored branch) Filters do not work correctly in the Japanese object name
- Rewriting README.md HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pgaudit.