4 ms·

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 installatio

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

sofixa 2y ago
And this, kids, is a good example of why homebrew is not a real package manager, and why macOS is not the best at running production services. I hope you have a backup somewhere else, not on the Mac Mini. One option would be to restore it on another machine on Postgres 14, follow the upgrade path to 17 (idk if you can jump directly but a few Google searches will cover this), verify the data, back up the new db, somehow upgrade Posgtres on your Mac, and restore the new back up. Done.
- mxey 2y ago
  I don’t see how this is homebrew‘s fault? Homebrew lets you install multiple versions of PostgreSQL at once, which you need for pg_upgrade, just like you can do with APT brew install postgresql@17
  - deleted 2y ago
    [deleted]
thrdbndndn 2y ago
Forget about something as major as Postgres, I have trouble updating packages (that aren't install via pip/npm/cargo) on Linux all the time as a newbie. The experience is worse than Windows for some reason. Hell, I have a hard time to tell the version of some system build-in binaries. A few months ago, I have trouble to unzip a file which turns out ot be AES-encrypted. Some answers on SO [1] saying I should update my `unzip` to newer version but I can't find any updates for my distro, and I have no idea (still no, so feel free to teach me) to update it manually to make my `unzip` supporting AES. And all the versions, the good and the bad, all say they're "version 6.0.0" despite they behavior obviously differently. [1] https://stackoverflow.com/questions/60674080/how-to-open-winzip-password-protected-archive/60676298#60676298 https://stackoverflow.com/questions/60674080/how-to-open-win...
- sofixa 2y ago
  > I have trouble updating packages (that aren't install via pip/npm/cargo) on Linux all the time as a newbie. The experience is worse than Windows for some reason If you haven't installed them via your programming language's package manager, you either installed them manually or via the OS package manager. The first one you'd know how to upgrade, and for the second you can ask it what version it is and what version is available to upgrade to (for compatibility reasons it might not be the latest, or latest major, unless you use the software vendor's own package manager repositories). It's actually much easier than in Windows, because you have a piece of software (package manager) that is your one stop shop to knowing what is installed, update it, check versions available, etc. unless you've manually installed stuff. In Windows you... google and download random .exes? Cool. As good as the worst possible option on Linux.
  - thrdbndndn 2y ago
    Not exactly random. It's not hard to tell which website is official 7-zip website. Also choco and scoop exist on Windows. > As good as the worst possible option on Linux. I understand this is not a fair comparison, but in practice, they're not as easy. When using Windows, I usually use it with a proper GUI interface, so popping up a browser and download the newest installer for a software from their official website would take me less than 1 min. Doing similar for my Linux VPS with only a terminal is much more complicated.
    - MaKey 2y ago
      > Doing similar for my Linux VPS with only a terminal is much more complicated. sudo apt-get install p7zip-full
      - thrdbndndn 2y ago
        I'm replying to the "the worst possible option on Linux", i.e. when the said software is not available in package manager. 7-zip is just a (bad) example; since you can install 7-zip using `choco install 7zip.install` on Windows too. I meant to say when you can't find the software you want in package manager, it's easier to download it manually and install it on Windows than (again, unfair comparison) a terminal-only Linux server.
Klonoar 2y ago
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.
- vbezhenar 2y ago
  % 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.

sofixa 2y ago

And this, kids, is a good example of why homebrew is not a real package manager, and why macOS is not the best at running production services. I hope you have a backup somewhere else, not on the Mac Mini. One option would be to restore it on another machine on Postgres 14, follow the upgrade path to 17 (idk if you can jump directly but a few Google searches will cover this), verify the data, back up the new db, somehow upgrade Posgtres on your Mac, and restore the new back up. Done.

mxey 2y ago
I don’t see how this is homebrew‘s fault? Homebrew lets you install multiple versions of PostgreSQL at once, which you need for pg_upgrade, just like you can do with APT brew install postgresql@17
- deleted 2y ago
  [deleted]

thrdbndndn 2y ago

Forget about something as major as Postgres, I have trouble updating packages (that aren't install via pip/npm/cargo) on Linux all the time as a newbie. The experience is worse than Windows for some reason. Hell, I have a hard time to tell the version of some system build-in binaries. A few months ago, I have trouble to unzip a file which turns out ot be AES-encrypted. Some answers on SO [1] saying I should update my `unzip` to newer version but I can't find any updates for my distro, and I have no idea (still no, so feel free to teach me) to update it manually to make my `unzip` supporting AES. And all the versions, the good and the bad, all say they're "version 6.0.0" despite they behavior obviously differently. [1] https://stackoverflow.com/questions/60674080/how-to-open-winzip-password-protected-archive/60676298#60676298 https://stackoverflow.com/questions/60674080/how-to-open-win...

sofixa 2y ago
> I have trouble updating packages (that aren't install via pip/npm/cargo) on Linux all the time as a newbie. The experience is worse than Windows for some reason If you haven't installed them via your programming language's package manager, you either installed them manually or via the OS package manager. The first one you'd know how to upgrade, and for the second you can ask it what version it is and what version is available to upgrade to (for compatibility reasons it might not be the latest, or latest major, unless you use the software vendor's own package manager repositories). It's actually much easier than in Windows, because you have a piece of software (package manager) that is your one stop shop to knowing what is installed, update it, check versions available, etc. unless you've manually installed stuff. In Windows you... google and download random .exes? Cool. As good as the worst possible option on Linux.
- thrdbndndn 2y ago
  Not exactly random. It's not hard to tell which website is official 7-zip website. Also choco and scoop exist on Windows. > As good as the worst possible option on Linux. I understand this is not a fair comparison, but in practice, they're not as easy. When using Windows, I usually use it with a proper GUI interface, so popping up a browser and download the newest installer for a software from their official website would take me less than 1 min. Doing similar for my Linux VPS with only a terminal is much more complicated.
  - MaKey 2y ago
    > Doing similar for my Linux VPS with only a terminal is much more complicated. sudo apt-get install p7zip-full
    - thrdbndndn 2y ago
      I'm replying to the "the worst possible option on Linux", i.e. when the said software is not available in package manager. 7-zip is just a (bad) example; since you can install 7-zip using `choco install 7zip.install` on Windows too. I meant to say when you can't find the software you want in package manager, it's easier to download it manually and install it on Windows than (again, unfair comparison) a terminal-only Linux server.

Klonoar 2y ago

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.

vbezhenar 2y ago
% 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.