Pavel Luzanov: PostgreSQL 19: part 5.3 (DBA3 and DBS) of CommitFest 2026-03

2026-10-20来源 Planet PostgreSQLEnglish

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

...

原文：https://www.a8q9.cn/en/article/pavel-luzanov-postgresql-19-part-5-3-dba3-and-dbs-of-commitfest-2026-03-7a340e.html

相关文章