Skip to content

Data analysis and correction tools for auditing a Postgres database

License

Notifications You must be signed in to change notification settings

wingspan/wingspan-auditing

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

30 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

wingspan-auditing

Wingspan Auditing is a library of Postgres stored procedures for data analysis and correction tools, as well as a bolt-on auditing solution. These techniques came out of developments from consulting projects.

Package structure:

  • Examples
    • Sample schema(s) / data setup to show how the package works
  • Audit
    • Code to create the audit structure (minimum viable useful functionality)
  • Analysis
    • Samples of functionality that can be executed with readonly privileges
  • Correction
    • Features to do data corrections (undo / rollback / etc)

Setup:

  • Set up a Postgres database (9.3+ supported, but some functionality may work on older versions). Note this has been tested against Heroku Postgres.
  • Ensure that psql is on your path
  • To use the example schema, edit install_movies.sh to have correct connection information
  • Run ./install_movies.sh
  • OR run install_auditing.sql with psql against your own database

Common Configuration Changes:

  • You may wish to exclude specific columns or column types from auditing. This can be controlled by changing audit/create_triggers.sql
  • You may wish to change which information is used as 'context' data (username, request ID, etc) - this can be controlled by changing audit/context.sql

References

Articles

About

Data analysis and correction tools for auditing a Postgres database

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages