Skip to content
This repository has been archived by the owner on Aug 7, 2023. It is now read-only.

pgAudit Log to File is an addon for pgAudit to redirect audit logs to an independent file

License

Unknown, Unknown licenses found

Licenses found

Unknown
LICENSE
Unknown
COPYING
Notifications You must be signed in to change notification settings

gridscale/pgauditlogtofile

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

33 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

pgAudit Log to File

pgAudit Log to File is an addon to pgAudit than will redirect audit log lines to an independent file, instead of using PostgreSQL server logger.

This will allow us to have an audit file that we can easily rotate without polluting server logs with those messages.

Audit logs in heavily used systems can grow very fast. This extension allows to automatically rotate the files based in a number of minutes.

Build

make install USE_PGXS=1

Installation

  • Build the extension
  • Add pgauditlogtofile to "shared_preload_libraries" in postgresql.conf
  • Restart PostgreSQL to reload new shared library
  • Create extension in postgres database (like pgaudit we don't need to create it in all the databases)
postgres=# CREATE EXTENSION pgauditlogtofile;

Configuration

pgaudit.log_directory

Name of the directory where the audit file will be created.

Scope: System

Default: 'log'

Empty or NULL will disable the extension and the audit logging will be done to PostgreSQL server logger.

pgaudit.log_filename

Name of the file where the audit will be written. Writing to an existing file will append the new entries.

This variable can contain time patterns up to minute to allow automatic rotation.

Scope: System

Default: 'audit-%Y%m%d_%H%M.log'

Empty or NULL will disable the extension and the audit logging will be done to PostgreSQL server logger.

pgaudit.log_rotation_age

Number of minutes after which the audit file will be rotated.

Scope: System

Default: 1440 minutes (1 day)

0 will disable the rotation

pgaudit.log_connections

Intercepts server log messages emited when log_connections is on

Scope: System

Default: off

Requires: log_connections = on

pgaudit.log_disconnections

Intercepts server log messages emited when log_disconnections is on

Scope: System

Default: off

Requires: log_disconnections = on

Test

cd test
vagrant plugin install vagrant-vbguest
vagrant up

About

pgAudit Log to File is an addon for pgAudit to redirect audit logs to an independent file

Resources

License

Unknown, Unknown licenses found

Licenses found

Unknown
LICENSE
Unknown
COPYING

Stars

Watchers

Forks

Packages

No packages published

Languages

  • C 89.5%
  • Dockerfile 8.6%
  • Makefile 1.9%