We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Auditing PostgreSQL Databases Using Logical Decoding

Formale Metadaten

Titel
Auditing PostgreSQL Databases Using Logical Decoding
Serientitel
Teil
13
Anzahl der Teile
193
Autor
Lizenz
CC-Namensnennung 3.0 Deutschland:
Sie dürfen das Werk bzw. den Inhalt zu jedem legalen Zweck nutzen, verändern und in unveränderter oder veränderter Form vervielfältigen, verbreiten und öffentlich zugänglich machen, sofern Sie den Namen des Autors/Rechteinhabers in der von ihm festgelegten Weise nennen.
Identifikatoren
Herausgeber
Erscheinungsjahr
Sprache

Inhaltliche Metadaten

Fachgebiet
Genre
Abstract
Have you ever been wondering what edits are happening inside your databases? Logcial Decoding, introduced in PostgreSQL 9.4, allows to keep track of changes commited to the database. This talk presents how this mechanism can be used to audit PostGIS/PostgreSQL databases. After an introduction to the concepts of logical decoding, two use cases are presented: Quality Assurance: writing an audit log into the database after each commit so that someone else can do a review of the modified data. Cache Invalildation: refreshing a GeoWebCache instance at the regions in which the data has changed after each commit. To support these two use cases, a little Java program able to be run as a mircoservice was developed and will be shared under an open source license with the community via github.