Scaling Postgres Episode 70 | Default Security | Max Connections | Progress Reporting | Migration

In this episode of Scaling Postgres, we discuss the default security, max_connections and pooling, progress reporting and migrating to Postgres.

Content Discussed

• PostgreSQL Deep Dive: PostgreSQL Defaults and Impact on Security - Part 1
• PostgreSQL Deep Dive: PostgreSQL Defaults and Impact on Security - Part 2
• The Challenges of Setting max_connections and Why You Should Use a Connection Pooler
• Postgres 12 highlight - More progress reporting
• Major Features: Postgres 12
• The Democratization of Databases
• PostgreSQL Administrator Account WITH NOLOGIN (recover your postgres role)
• Managing Multiple PostgreSQL Instances on Ubuntu/Debian
• Webinar: Migration to PostgreSQL [Follow up]
• Version 1.6 of pgwatch2 PostgreSQL monitoring tool released

YouTube Video