Postgres for the SQL Server DBA
summary
Practical checklist for SQL Server DBAs moving to Postgres: connection uses port 5432 and username/password (no Windows auth); GUIs recommended — DataGrip, DBeaver or PGAdmin — before learning psql; backups differ: logical pg_dump (slow restore) versus server-wide base backups and tools like PGBackRest or Barman; scheduling uses cron not SQL Agent; monitor WAL to avoid fills, limit DB connections (ideally under ~500), prefer schemas over many databases, and edit postgresql.conf under /etc on Linux.
AI-written summary · about
chapters (10)
- 0:00Introduction and background
- 3:01Getting started with Postgres
- 5:33Connection management
- 8:27Backup and recovery
- 16:28Architectural differences
- 20:26Functions and procedures
- 25:51Monitoring activity
- 31:23Performance tuning
- 38:04Configuration and OS
- 43:06Community and closing
related talks
45mSQL Server to PostgreSQL: Migration Challenges & Solutions
27mMigrating from MSSQL to PostgreSQL
20mCrossing The Streams: Adding PostgreSQL to Your SQL Server Skillset
45mDebugging Databases for Developers
59mPostgreSQL Don'ts and Dos
28mPostgreSQL vs. SQL Server: Security Model Differences
02h 30mTutorial
46mAn ultimate guide to upgrading your PostgreSQL installation