Auditing | Postgres.FM 029 |
Nikolay and Michael discuss auditing — why we might want it, what the options are, and even an idea for a future solution...
Here are links to a few things we mentioned:
* Crunchy Data PostgreSQL Security Technical Implementation Guide (STIG) https://www.crunchydata.com/blog/anno...
* pgAudit (site) https://www.pgaudit.org/
* pgAudit (repo) https://github.com/pgaudit/pgaudit
* noset (extension) https://gitlab.com/ongresinc/extensio...
* Splunk https://www.splunk.com/
* Kibana https://www.elastic.co/kibana/
* Timescale https://www.timescale.com/
* CREATE TRIGGER docs https://www.postgresql.org/docs/curre...
* Transition table triggers (blog post by David Fetter) http://databasedoings.blogspot.com/20...
* Table Audit (blog post by Lorenzo Alberton) https://www.alberton.info/postgresql_...
* Row change auditing options (blog post by CYBERTEC) https://www.cybertec-postgresql.com/e...
* Hydra founders interview (on Postgres TV) • Joe Sciarrino and Jonathan Dance. Hyd...
* max_slot_wal_keep_size https://pgpedia.info/m/max_slot_wal_k...
* eBPF https://en.wikipedia.org/wiki/EBPF
* Building a perf-like tool for PostgreSQL – Ronan Dunklau • Building a perf-like tool for Postgre...
* Party tricks for PostgreSQL: perf, ftrace and bpftrace – Dmitry Dolgov • Party tricks for PostgreSQL: perf, ft...
-------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.