Road to Percona Live 2022 - Jonathan Katz
summary
PostgreSQL 10 introduces SCRAM-SHA-256 so passwords can be verified without ever exchanging the secret and channel binding defends against MITM attacks, with guidance on how to upgrade existing accounts and what breaks in legacy md5 or cleartext schemes. PostgreSQL 15 surfaces concrete features: the MERGE command for conditional SQL, expanded SQL/JSON standard support, measurable performance gains in logical replication and faster backup and recovery paths that change how upgrades and restores actually behave.
AI-written summary · about
chapters (5)
related talks
55mGet Your Insecure PostgreSQL Passwords to SCRAM!
50mSecuring PostgreSQL From External Attack
32mEnhancing Security in PostgreSQL
54mConfiguration and Authentication
55mA look at the Elephants Trunk: PostgreSQL 14
52mA look at the Elephants Trunk - PostgreSQL 15
07mAll about Postgres security
35mSecuring PostgreSQL From External Attack