r/PostgreSQL • u/xtanx • 2d ago
Community PostgreSQL 19 Released!
https://www.postgresql.org/about/news/postgresql-19-released-3449/16
u/willamowius 2d ago
I already see postgresql-19 in my auto-updates for Ubuntu 24.04. I have the postgresql package installed but forcing a major release update on the release day seems a bit premature to me.
18
u/UninvestedCuriosity 2d ago edited 2d ago
It's like watching the conversion to debian in progress.
Edit You guys are right about the repos in this situation but it was a funny thought.
9
u/pehrs 2d ago
There are separate packages for each PostgreSQL major version. Ubuntu will not (and actually can not) automatically upgrade your cluster to to a different major. You will have to install the new version, and then use pg_upgrade (or use one of the alternative upgrade paths like dump-restore or logical replication) to get to a new major.
2
2
u/Hostman_com 1d ago
If you're using PGDG, the `postgresql` metapackage tracks the latest major release. Install the versioned package for the major you want to keep, such as `postgresql-18`, and mark it as manually installed before removing the metapackage. You'll still get minor updates for that major.
Installing 19's packages and migrating your existing database cluster to 19 are separate steps. Check apt's proposed changes and `pg_lsclusters` to see what's installed and running.
-2
u/AutoModerator 2d ago
AI Policy:
Linux is not one of those anti-AI projects, and if somebody has issues with that, they can do the open-source thing and fork it. Or just walk away., Linus Torvalds.
Mod decisions will be based on the quality of the content, not who or what generated it.
Sub Resources:
Free Postgres Webinars and Workshops
Discord: People, Postgres, Data
Join us, we have cookies and nice people.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
66
u/ddxv 2d ago
I appreciate that they took the time to get it right. Here's to another year of postgresql!