[SOLVED] How to upgrade to PostgreSQL 11 for Ubuntu 18.04?

Issue

As the title suggests I want to upgrade my postgresql-10 to postgresql-11.

I'm using ubuntu-18.04.

Solution

You can follow this blog setup Postgresql-11 on Ubuntu. I found it easy and simple.

Add the PostgreSQL package repository on your Ubuntu machine

echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main 11" | sudo tee /etc/apt/sources.list.d/pgsql.list

Add the GPG key of the PostgreSQL package repository:

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

Update APT and install postgresql-11

sudo apt update && sudo apt install postgresql-11

Answered By - Ravindra Singh Ratnawat