Databases
PostgreSQL 19
Generally available · Edition of
Version 19 adds sequence replication and new options for bringing a major-version migration online.
- Compatibility
- PostgreSQL 19’s pg_upgrade supports source clusters on PostgreSQL 9.2.x and later. External modules must also be binary-compatible. PostgreSQL
- Upgrade
- Moving data from an earlier major release requires pg_upgrade, dump and restore, or logical replication. PostgreSQL
- Rollback
- With pg_upgrade link mode, starting the new cluster changes shared files. Returning to the old cluster then requires restoring its backup. PostgreSQL
Milestone history
The project issued release candidate 2 alongside the last PostgreSQL 14 patch.
PostgreSQLPostgreSQL 19 reached general availability.
PostgreSQL