We’re continuing our review of the March CommitFest for PostgreSQL 19. This third article in the series covers the changes related to our DBA3 and DBS courses.

As a reminder, here’s the plan for our coverage of the final PostgreSQL 19 CommitFest:

Part 5.1 (QPT)

Part 5.2 (DBA1, DBA2)

Part 5.3 (DBA3, DBS) -- you are here 🙂

Part 5.4 (SQL, DEV1, DEV2)

For the earlier CommitFests, see: 2025-07, 2025-09, 2025-11, 2026-01.

Here’s what’s covered:

  • pg_verifybackup, pg_waldump: reading WAL from tar archives
  • pg_stat_recovery: monitoring replication and recovery
  • psql: replica indicator in the prompt
  • pg_createsubscriber --logdir: writing diagnostics to files
  • Publications: excluding specific tables
  • Logical replication subscriptions: connecting via postgres_fdw
  • wal_sender_shutdown_timeout: limiting the wait for WAL replication at shutdown
  • wal_receiver_timeout: per-user and per-subscription settings
  • SSL: server-side SNI
  • GRANT/REVOKE … GRANTED BY
  • Password expiration warning
  • MD5 passwords: more end-of-support preparations
  • pg_[read|write]_all_data: now for large objects too
  • psql: comments for publications, subscriptions, and extended statistics

...