Correct way to update PostgreSQL

[MattIPv4]

Output of brew config

HOMEBREW_VERSION: 4.0.15
ORIGIN: https://github.com/Homebrew/brew
HEAD: 763c41f006ab9b44261e313b0aaa24a047431b06
Last commit: 9 hours ago
Core tap origin: https://github.com/Homebrew/homebrew-core
Core tap HEAD: 7663be5c6d2157cb63be9f2ecc2fed6768297997
Core tap last commit: 9 weeks ago
Core tap branch: master
Core tap JSON: 24 Apr 17:17 UTC
HOMEBREW_PREFIX: /usr/local
HOMEBREW_CASK_OPTS: []
HOMEBREW_DISPLAY: /private/tmp/com.apple.launchd.sKXtmsIFBd/org.xquartz:0
HOMEBREW_MAKE_JOBS: 8
Homebrew Ruby: 2.6.10 => /usr/local/Homebrew/Library/Homebrew/vendor/portable-ruby/2.6.10_1/bin/ruby
CPU: octa-core 64-bit kabylake
Clang: 14.0.0 build 1400
Git: 2.39.0 => /usr/local/bin/git
Curl: 7.86.0 => /usr/bin/curl
macOS: 13.2.1-x86_64
CLT: N/A
Xcode: 14.2

Output of brew doctor

Please note that these warnings are just used to help the Homebrew maintainers
with debugging if you file an issue. If everything you use Homebrew for is
working fine: please don't worry or file an issue; just ignore this. Thanks!

Warning: Unbrewed dylibs were found in /usr/local/lib.
If you didn't put them there on purpose they could cause problems when
building Homebrew formulae, and may need to be deleted.

Unexpected dylibs:
  /usr/local/lib/libjack.0.dylib
  /usr/local/lib/libjacknet.0.dylib
  /usr/local/lib/libjackserver.0.dylib

Warning: Unbrewed header files were found in /usr/local/include.
If you didn't put them there on purpose they could cause problems when
building Homebrew formulae, and may need to be deleted.

Unexpected header files:
  /usr/local/include/jack/control.h
  /usr/local/include/jack/intclient.h
  /usr/local/include/jack/jack.h
  /usr/local/include/jack/jslist.h
  /usr/local/include/jack/metadata.h
  /usr/local/include/jack/midiport.h
  /usr/local/include/jack/net.h
  /usr/local/include/jack/ringbuffer.h
  /usr/local/include/jack/session.h
  /usr/local/include/jack/statistics.h
  /usr/local/include/jack/systemdeps.h
  /usr/local/include/jack/thread.h
  /usr/local/include/jack/transport.h
  /usr/local/include/jack/types.h
  /usr/local/include/jack/uuid.h
  /usr/local/include/jack/weakjack.h
  /usr/local/include/jack/weakmacros.h
  /usr/local/include/python3.6m/pygame/_camera.h
  /usr/local/include/python3.6m/pygame/_pygame.h
  /usr/local/include/python3.6m/pygame/_surface.h
  /usr/local/include/python3.6m/pygame/bitmask.h
  /usr/local/include/python3.6m/pygame/camera.h
  /usr/local/include/python3.6m/pygame/fastevents.h
  /usr/local/include/python3.6m/pygame/font.h
  /usr/local/include/python3.6m/pygame/freetype.h
  /usr/local/include/python3.6m/pygame/mask.h
  /usr/local/include/python3.6m/pygame/mixer.h
  /usr/local/include/python3.6m/pygame/pgarrinter.h
  /usr/local/include/python3.6m/pygame/pgbufferproxy.h
  /usr/local/include/python3.6m/pygame/pgcompat.h
  /usr/local/include/python3.6m/pygame/pgopengl.h
  /usr/local/include/python3.6m/pygame/pygame.h
  /usr/local/include/python3.6m/pygame/scrap.h
  /usr/local/include/python3.6m/pygame/surface.h
  /usr/local/include/ublio.h

Warning: Unbrewed '.pc' files were found in /usr/local/lib/pkgconfig.
If you didn't put them there on purpose they could cause problems when
building Homebrew formulae, and may need to be deleted.

Unexpected '.pc' files:
  /usr/local/lib/pkgconfig/jack.pc

Warning: You have unlinked kegs in your Cellar.
Leaving kegs unlinked can lead to build-trouble and cause formulae that depend on
those kegs to fail to run properly once built. Run `brew link` on these:
  git-lfs
  tcl-tk
  node
  [email protected]

Warning: Your Xcode (14.2) is outdated.
Please update to Xcode 14.3 (or delete it).
Xcode can be updated from the App Store.

Description of issue

I have postgresql@14 installed. I would like to update to postgresql@15. My data directory is /usr/local/var/postgres.

With postgresql@14 installed and linked, pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start runs as expected.

I stopped the DB and installed postgresql@15 but did not link it -- postgres --version still shows 14.

I attempt to run brew postgresql-upgrade-database -v, but get back:

Warning: Use postgresql@14 instead of deprecated postgresql
Error: postgresql data already upgraded!

If I unlink postgresql@14 (but leave it installed) and link postgresql@15, such that postgres --version returns 15, and then run brew postgresql-upgrade-database -v, I get back the same:

Warning: Use postgresql@14 instead of deprecated postgresql
Error: postgresql data already upgraded!

Even if I uninstall postgresql@14 completely, running the upgrade command still returns the same error. What am I doing wrong?

[MattIPv4]

Decided to just use pg_upgrade directly:

1. Moved the unversioned data to be the v14 data: mv /usr/local/var/postgres /usr/local/var/postgresql@14
2. Installed postgresql@15 alongside postgresql@14
3. Used pg_upgrade: /usr/local/opt/postgresql@15/bin/pg_upgrade -b /usr/local/opt/postgresql@14/bin -B /usr/local/opt/postgresql@15/bin -d /usr/local/var/postgresql@14 -D /usr/local/var/postgresql@15
4. Uninstalled postgresql@14
5. Linked postgresql@15

[aheydari-rescale]

for my case I was using Homebrew following works which is inspired by @MattIPv4 response:

 pg_upgrade -b /opt/homebrew/Cellar/postgresql@12/12.16/bin -d /opt/homebrew/var/postgresql@12 -D /opt/homebrew/var/postgresql@14

[Kyu]

14 -> 15

brew install postgres@15
/opt/homebrew/Cellar/postgresql@15/15.6_1/bin/pg_upgrade -b /opt/homebrew/Cellar/postgresql@14/14.11_1/bin -d /opt/homebrew/var/postgresql@14 -D /opt/homebrew/var/postgresql@15