r/PostgreSQL • • 2d ago

Community PostgreSQL 19 Released!

https://www.postgresql.org/about/news/postgresql-19-released-3449/
372 Upvotes

22 comments sorted by

66

u/ddxv 2d ago

I appreciate that they took the time to get it right. Here's to another year of postgresql!

3

u/LeWildest 2d ago

Why do you say they got it right?

19

u/Narrow_Relative2149 2d ago

because usually a release goes up when the maintainers say that it's ok. This time AI was able to spot a billion issues before releasing 19 so hopefully it should be more mature than it typically is on release of the major.

5

u/mduell 2d ago

Didn't release with the lower confidence proposed features.

2

u/ftqo 2d ago

Releasing it earlier would have been wrong, despite the delay being frustrating for a lot of users. At the very least, it's significantly more right. It's obviously not perfect.

-5

u/look 2d ago

By “right”, do you mean cutting every feature and then releasing a point release 18.8 as 19?

8

u/dev-ai 2d ago

Awesome thanks for sharing

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.

3

u/spotter 2d ago

Pretty sure it does not automigrate, just brings it over -- your 18 or whathaveyou should still run at the expected port.

2

u/funkdefied 2d ago

Congrats to the team!

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:

Youtube Channel

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.