A Step-by-Step Guide to upgrade postgresql from 9-6 to 10 on ubuntu 16 1.Make a backup. Make sure that your database is not being updated. pg_dumpall > outputfile 2. Install Postgres 10. a) Create the file /etc/apt/sources.list.d/pgdg.list and add a line for the repository deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main b) Import the repository signing key, and update the package lists wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - sudo apt-get update 3. Run sudo apt-get install postgresql-10 . A newer version will be installed side-by-side with the earlier version. 4. Run pg_lsclusters: Ver Cluster Port Status Owner Data directory Log file 9.6 main 5433 online postgres /9.6/main /var/log/postgresql/postgresql-9.6-main.log 10 main 5432 online postgres /10/main /var/log/postgr