Get Your Insecure PostgreSQL Passwords to SCRAM - Secure Authentication Methods
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it Explore the evolution and security of PostgreSQL password authentication in this comprehensive conference talk. Delve into the history of password storage methods, examining flaws in legacy authentication systems. Learn about SCRAM (Salted Challenge Response Authentication Mechanism) introduced in PostgreSQL 10, understanding its step-by-step algorithm and benefits. Discover how to implement SCRAM-SHA-256, prevent man-in-the-middle attacks through channel binding, and safely upgrade existing passwords. Gain insights into ensuring PostgreSQL driver compatibility with SCRAM and why it's crucial to transition from older password mechanisms for enhanced database security.