←back to thread

Why does everyone run ancient Postgres versions?

(neon.tech)
264 points davidgomes | 1 comments | 17 Oct 24 21:23 UTC | HN request time: 0s | source
Show context
vivzkestrel ◴[18 Oct 24 06:11 UTC] No.41876746[source]▶
i ll tell you why from my end. I installed Postgres14 via homebrew many years ago on my Apple M1 mac mini. I searched a lot on how to "upgrade" this installation but found nothing. I have a few databases running with data on it which I can't afford to lose if something goes down for more than 1 hour. I wish someone would guide me on how to actually install a newer postgres such as v17 without breaking an existing v14 install or losing data since I am not an expert by any means
replies(3): >>41876775 #>>41876779 #>>41877506 #
Klonoar ◴[18 Oct 24 08:48 UTC] No.41877506[source]▶
This kind of sounds like a Homebrew issue…?

I’ve run multiple variants of PostgreSQL on my MacBook under MacPorts. Can’t even remember the last time I thought about it, to be honest.

replies(1): >>41878096 #
1. vbezhenar ◴[18 Oct 24 10:40 UTC] No.41878096[source]▶

    % brew search postgres
    ==> Formulae
    check_postgres      postgresql@12       postgresql@15       postgrest
    postgresql@10       postgresql@13       postgresql@16       qt-postgresql
    postgresql@11       postgresql@14       postgresql@17       postgis
Looks like "user issue" to me.