Upgrade postgresql 14 to 16

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