Skip to content

Instantly share code, notes, and snippets.

@alextakitani

alextakitani/gist:b430958327bc44954f2a1b486141d64d

Last active December 26, 2023 14:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alextakitani/b430958327bc44954f2a1b486141d64d to your computer and use it in GitHub Desktop.
Save alextakitani/b430958327bc44954f2a1b486141d64d to your computer and use it in GitHub Desktop.
Download ZIP
Upgrade postgresql 14 to 16
Raw
gistfile1.txt
# remember to remove old dbs, old extensions and stuff like that, it all adds up to the time it's going to take
# this works fine for 15 also
sudo apt-get install postgresql-16 postgresql-server-dev-16
# mine neededs hypopg
cd /tmp
curl -L https://github.com/HypoPG/hypopg/archive/1.1.4.tar.gz | tar xz
cd hypopg-1.1.4
make
sudo make install
sudo pg_dropcluster 16 main --stop
sudo pg_upgradecluster 14 main
#Test everything first
sudo pg_dropcluster 14 main
sudo apt purge postgresql-14 postgresql-client-14
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment