All about Postgres security
summary
Covers concrete steps to harden PostgreSQL by layering network, host, app and data protections and showing which features to enable and how. Explains PostgreSQL auth methods and when to use them with examples trust, md5, scram and certificate-based auth, details on OS vs internal auth, and how to protect specific columns or tables using built‑in encryption and role privileges. Shows how to capture activity for auditing and monitoring with logging and tools like Percona PMM and frames security as authentication authorization accounting with practical config and tradeoffs.
AI-written summary · about
chapters (5)
- 0:00Introduction
- 0:39Security fundamentals
- 1:25Holistic security approach
- 3:42The AAA security model
- 5:10PostgreSQL authentication
related talks
35mSecuring PostgreSQL From External Attack
50mSecuring PostgreSQL
50mPostgreSQL Security. How Do We Think?
54mConfiguration and Authentication
28mFrom Dev to Prod: Securing Postgres the Right Way
45mSecurity Attacks on PostgreSQL
32mEnhancing Security in PostgreSQL
32mPostgreSQL Security: Defending Against External Attacks