Skip to content

FOLLOW THE EVOLUTION

PostgreSQL 9.4 Catalog Changes

Start from a single upgrade and see how catalogs, columns, and types changed.
Compare any two versions, or walk forward through the release history.

PostgreSQL 9.3 → 9.4
pg_aggregateStructural change
+ aggkind+ aggnumdirectargs+ aggmtransfn+ aggminvtransfn+ aggmfinalfn+ aggfinalextra+ aggmfinalextra+ aggtransspace+ aggmtranstype+ aggmtransspace+ aggminitval
pg_classStructural change
+ relreplident− reltoastidxid
pg_indexStructural change
+ indisreplident
pg_replication_slotsCatalog added
+ slot_name+ plugin+ slot_type+ datoid+ database+ active+ xmin+ catalog_xmin+ restart_lsn
pg_stat_archiverCatalog added
+ archived_count+ last_archived_wal+ last_archived_time+ failed_count+ last_failed_wal+ last_failed_time+ stats_reset
pg_stat_replicationStructural change
+ backend_xmin~ flush_location: text → pg_lsn~ replay_location: text → pg_lsn~ sent_location: text → pg_lsn~ write_location: text → pg_lsn