lecture: Auditing PostgreSQL Databases Using Logical Decoding
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.
Links to project: http://github.com/sebastian-r-schmidt/logicaldecoding/
Start time: 17:00
Room: Plenary Chamber
- Room Berlin
- One year of open governance for OTB: thoughts and context
- Plenary Office
- The Blue Hub, an integrated analysis platform with a WebGIS front-end to exploit maritime Big Data
- Fireplace Room
- Visualizing uncertainty in data
- Room Bonn
- geotiff.js and plotty.js - Visualizing Scientific Raster Data in the Browser
- Rhine Lobby
- Analysing the practical feasibility of FOSSGIS in military operations – A Cholera outbreak use case