Скачать или смотреть Scaling Postgres Episode 70 | Default Security | Max Connections | Progress Reporting | Migration

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...

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

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...

Timestamps:
00:00 - Intro
00:22 - PostgreSQL Deep Dive: PostgreSQL Defaults and Impact on Security - Part 1
03:43 - PostgreSQL Deep Dive: PostgreSQL Defaults and Impact on Security - Part 2
05:48 - The Challenges of Setting max_connections and Why You Should Use a Connection Pooler
08:11 - Postgres 12 highlight - More progress reporting
08:54 - Major Features: Postgres 12
09:36 - The Democratization of Databases
09:56 - PostgreSQL Administrator Account WITH NOLOGIN (recover your postgres role)
10:45 - Managing Multiple PostgreSQL Instances on Ubuntu/Debian
11:25 - Webinar: Migration to PostgreSQL [Follow up]
12:00 - Version 1.6 of pgwatch2 PostgreSQL monitoring tool released
12:33 - Outro

#postgres #postgresql