Ah, looks like psql seems to have switched to actually using minor and major ver... | Hacker News

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

login

mschuster91 on Aug 9, 2023 | parent | context | favorite | on: When did Postgres become cool?

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

justinclift on Aug 9, 2023 [–]

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