Upgrade Ubuntu 16.04 postgres from 9 to 12

<p>Add the repo:</p> <pre><code>sudo echo 'deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main' &gt; /etc/apt/sources.list.d/pgdg.list </code></pre> <p>Import the key:</p> <pre><code>wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - </code></pre> <p>Update:</p> <pre><code>sudo apt update </code></pre> <p>Install:</p> <pre><code>sudo apt install postgresql-12 postgresql-client-12 postgresql-contrib-12 </code></pre> <p>Stop:</p> <pre><code>sudo pg_dropcluster 12 main --stop </code></pre> <p>Migrate:</p> <pre><code>sudo pg_upgradecluster 9.5 main </code></pre> <p>Remove:</p> <pre><code>sudo pg_dropcluster 9.5 main </code></pre> <p>Check:</p> <pre><code>sudo systemctl status postgresql </code></pre> <p>Double check:</p> <pre><code>pg_dump -V </code></pre> <p>From: https://gist.github.com/Clark-G/01fcb84c658c44dcec4af1a965e2c3b4</p>