Pre-upgrade assessment

Situation

You are about to upgrade PostgreSQL (or an extension like PostGIS or pgvector) and need to know what is exposed: version currency, deprecated settings, extension compatibility, storage headroom.

Commands

pgdba check --only extension.version,config.version,storage.free
pgdba config doctor                        # is the config itself healthy?

What pgdba does

The extension and config checks compare what you run against what is current, flag pending_restart settings, and surface storage headroom — all read-only, all with the exact remediation (or the ignore-if that says you are fine).

Done looks like

A short list of upgrade blockers vs. safe-to-ignore items, produced before the maintenance window instead of during it.