Hacker News new | past | comments | ask | show | jobs | submit login

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.




Join us for AI Startup School this June 16-17 in San Francisco!

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

Search: