PostgreSQL 18 on Amazon Aurora and Amazon RDS: Security, monitoring, and developer enhancements (opens in new tab)

PostgreSQL 18 brings several security, monitoring, and developer enhancements relevant to Amazon RDS and Aurora PostgreSQL users. Key changes include: deprecation of MD5 password authentication in favor of SCRAM-SHA-256 with a new md5_password_warnings parameter; new parallel worker tracking columns in pg_stat_database and pg_stat_statements to detect worker shortages; expanded pg_stat_subscription_stats with seven new conflict-type columns for logical replication diagnostics; automatic optim...