Why Does Everyone Run Ancient Postgres Versions?

Re:Why Does Everyone Run Ancient Postgres Versions? by whizzter on Friday October 18, 2024 @07:05AM (#41878252)

I think one really BIG factor is that built-in logical replication wasn't introduced until PostgreSQL 10 in 2017, before that you only had physical replication for master-slave but iirc that didn't work between versions so doing a "hot" upgrade was more or less impossible without third-party tools iirc.

So even if it's available these days, the amount of people still subjected to upgrades from older version still leaves an impression that it's really bad.

[ Parent | on HN ]

Re:Why Does Everyone Run Ancient Postgres Versions? by creshal on Friday October 18, 2024 @08:09AM (#41878641)

Yeah, everywhere I worked there's usually two clusters of postgres databases

- whatever made it past the postgres 10 hump is on the most recent version and keeps getting migrated

- whatever is still on 9.x is scheduled to remain that way until the product using it will be EOL'd

[ Parent | on HN ]

Re:Why Does Everyone Run Ancient Postgres Versions? by RegnisGnaw on Friday October 18, 2024 @09:30AM (#41879287)

There is still major issues with logical replication, mainly limited feature support.

[ Parent | on HN ]

Re:Why Does Everyone Run Ancient Postgres Versions? by whizzter on Saturday October 19, 2024 @11:40AM (#41888427)

What's lacking? Specific types or schema changes?

[ Parent | on HN ]

Re:Why Does Everyone Run Ancient Postgres Versions? by RegnisGnaw on Sunday October 20, 2024 @09:38PM (#41899965)

I don't care much about schema changes as I can setup logical replication just for the major version upgrade. The main issue is the lack of support for large objects, which the code bases I'm dealing with uses heavily.

[ Parent | on HN ]