Free to read · get new articles by email
The Pressentify Blog
Backend engineering, explained for people who ship.
Tag
#pg-upgrade
2 articles
PostgreSQL 14 stops getting fixes on 12 November. Go to 18 now, or wait for 19?
Thirteen days from now PostgreSQL 14 gets its last release. Version 19 reaches GA a week after that. A decision table by risk profile, a pg_upgrade runbook with the flags I checked on 18.6, and what to do if you cannot move in time.
· 4 min
PostgreSQL 19 RC1: the incompatible changes to test before GA on 19 November
JIT is off by default, TOAST compression becomes lz4, RADIUS is gone, standard_conforming_strings is forced on, and btree_gist inet/cidr indexes block pg_upgrade. A test plan and a query that finds the indexes, checked on Postgres 18.6.
· 4 min
Get the next one in your inbox
One practical backend article at a time. No spam; unsubscribe in one click.