Hacker News new | ask | show | jobs
by justinclift 1042 days ago
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.
1 comments
mschuster91 1042 days ago
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

link
justinclift 1042 days ago
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.

link