How to Install PostgreSQL 9.6 on Linux Mint 18.1 Serena



How to install PostgreSQL 9.6 on Linux Mint 18.1 Serena?


The PostgreSQL Global Development Group (PGDG) maintains an APT repository of PostgreSQL packages for Debian and Ubuntu located at

What's currently supported:

  • Debian 7 (wheezy), 8 (jessie), 9 (stretch), and unstable (sid)
  • Ubuntu 14.04 (trusty), 16.04 (xenial), 17.04 (zesty)
  • Architectures: amd64 (64-bit x86), i386 (32-bit x86), ppc64el (little-endian 64-bit POWER; not on wheezy/precise)
  • PostgreSQL 9.1, 9.2, 9.3, 9.4, 9.5, 9.6, 10devel
  • Server extensions such as Slony-I, various PL languages, and datatypes
  • Applications like pgadmin3, pgbouncer, and pgpool-II

As Linux Mint 18.1 is based on Ubuntu 16.04 (xenial), here's the installation steps:

  1. Create a file at /etc/apt/sources.list.d/postgresql.list with the following command:
    $ sudo sh -c 'echo "deb xenial-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

  2. Import repository key:
    $ wget --quiet -O - | sudo apt-key add -

  3. Update apt-get:
    $ sudo apt-get update
    $ sudo apt-get upgrade

  4. Install PostgreSQL 9.6:
    $ sudo apt-get install postgresql-9.6

  5. Change postgres user password:
    $ sudo su - postgres
    $ psql
    postgres=# ALTER USER postgres WITH PASSWORD 'some-secret-password';
    postgres=# \q

  6. Optional: Install PostgreSQL GUI client - pgadmin3:
    $ sudo apt-get install pgadmin3





1 comment

  1. Thank you for the auspicious writeup. It in fact was a amusement account it.

    Look advanced to far added agreeable from you! However, how could we communicate?

Leave a reply

Your email address will not be published. Required fields are marked *