Last active
August 19, 2019 07:47
-
-
Save sydneyitguy/b9b2d272d8d2b160bb97c20fa9eace22 to your computer and use it in GitHub Desktop.
PostgreSQL upgrade from 10 to 11
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
sudo apt install wget ca-certificates | |
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - | |
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" >> /etc/apt/sources.list.d/pgdg.list' | |
psql --version | |
sudo apt update | |
sudo apt install postgresql-11 | |
pg_lsclusters | |
sudo pg_dropcluster 11 main --stop | |
sudo pg_upgradecluster 10 main | |
sudo pg_dropcluster 10 main | |
pg_lsclusters | |
dpkg -l | grep postgresql | |
sudo apt purge postgresql-10 postgresql-client-10 postgresql-contrib-10 | |
psql --version |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment