Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Oracle fucks you in pricing, PostgreSQL in the effort required to pull off a minor version upgrade.


What's the situation where minor version upgrades are giving you trouble?

Asking because it's not supposed to be troublesome. In theory (!), minor version upgrades don't require any change to the on-disk data, so you should be able to just upgrade your PG binaries then restart the database.


Ah, looks like psql seems to have switched to actually using minor and major versions properly during the last two years - I remember the dance from the 9.x versions and postgres-upgrade [1].

In any case it's way more straightforward with mysql.

[1] https://hub.docker.com/r/tianon/postgres-upgrade


For Docker usage you'll probably be better off with the "automatic upgrade" images instead:

https://hub.docker.com/r/pgautoupgrade/pgautoupgrade

---

That being said, those pgautoupgrade images are alpine Linux based.

People coming from non-alpine Linux images of PostgreSQL will probably need that older not-automatic approach you linked to.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: