Auditing | Postgres.FM 029 | #PostgreSQL #Postgres podcast

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/announcing-the-crunchy-data-postgresql-stig
* pgAudit (site) https://www.pgaudit.org/
* pgAudit (repo) https://github.com/pgaudit/pgaudit
* noset (extension) https://gitlab.com/ongresinc/extensions/noset/
* Splunk https://www.splunk.com/
* Kibana https://www.elastic.co/kibana/
* Timescale https://www.timescale.com/
* CREATE TRIGGER docs https://www.postgresql.org/docs/current/sql-createtrigger.html
* Transition table triggers (blog post by David Fetter) http://databasedoings.blogspot.com/2017/07/cool-stuff-in-postgresql-10-transition.html
* Table Audit (blog post by Lorenzo Alberton) https://www.alberton.info/postgresql_table_audit.html
* Row change auditing options (blog post by CYBERTEC) https://www.cybertec-postgresql.com/en/row-change-auditing-options-for-postgresql/
* Hydra founders interview (on Postgres TV) https://www.youtube.com/watch?v=71eD53ltbMs
* max_slot_wal_keep_size https://pgpedia.info/m/max_slot_wal_keep_size.html
* eBPF https://en.wikipedia.org/wiki/EBPF
* Building a perf-like tool for PostgreSQL – Ronan Dunklau https://www.youtube.com/watch?v=tvJgMV-8nfU
* Party tricks for PostgreSQL: perf, ftrace and bpftrace – Dmitry Dolgov https://www.youtube.com/watch?v=J9CegWlWyKo

-------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov https://twitter.com/samokhvalov and @michristofides https://twitter.com/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.