Breakout Session

on YouTube ↗44m

" summary

Compares concrete migrations: psql client with tab completion and backslash commands (\l, \dt, \d) replaces MySQL SHOW; role‑based accounts replace MySQL users and rely on pg_hba.conf ordering; backups use pg_basebackup for physical and pg_dump for logical; streaming replication ships WAL files so set wal_level=hot_standby, configure max_wal_senders, archive_command and wal_keep_segments, create recovery.conf, and monitor with pg_stat_activity and pg_stat_replication; autovacuum and vacuum (vacuum full) reclaim space.

AI-written summary · about

" chapters (19)

1. 0:00Intro
2. 1:37Schema
3. 2:17Database
4. 6:17Distributions
5. 6:42Overview
6. 9:00Post Install
7. 9:23Configuration Files
8. 11:09MySQL Access Privilege
9. 11:49Postgres Access Privilege
10. 13:21pg_hba.conf
11. 15:54CLI
12. 19:49PG Data Directory
13. 23:17MySQL Replication
14. 24:03Postgres Replication
15. 25:08Streaming Replication
16. 27:22Primary postgresql.conf
17. 29:49recovery.conf
18. 39:00PL/SQL
19. 40:45MySQL vs PostgreSQL

" related talks

• 31m#PostgreSQL to #MySQL: A DBA PerspectivePatrick King · Percona Live Open Source Database Conference 2017
• 36mTales from the Postgres Front, and What We Can LearnMarc Linster · PostgresOpen 2014
• 50mMoving from MSSQL to pgSQL – High Availability and Disaster RecoveryRick Lowe · Postgres Conference Orlando 2025
• 21mGetting ready for PostgreSQL 9.1Gabriele Bartolini, Marco Nenciarini, Harald Armin Massa · EuroPython 2011
• 50mAn ultimate guide to upgrading your PostgreSQL installationIlya Kosmodemiansky · PostgreSQL Conference Europe 2024
• 46mAn ultimate guide to upgrading your PostgreSQL installationIlya Kosmodemiansky · PostgresOpen Silicon Valley 2017
• 50mA look at the elephant's trunk - PostgreSQL 10Magnus Hagander · PostgresOpen Silicon Valley 2017
• 50mPostgreSQL Backup and Recovery MethodsKevin Kempter · PostgresOpen 2013