How to Install PostgreSQL 9.6 on Ubuntu 18.04 LTS (Linux)

How to Install PostgreSQL 9.6 on Ubuntu 18.04 LTS

PostgreSQL install ubuntu

POSTGRESQL is an open-source, full-featured relational database.PostgreSQL is the most advanced open source relational database, MySQL did not have triggers, PostgreSQL did.
In this tutorial we will see How to Install PostgreSQL 9.6 on Ubuntu 18.04 LTS. The same procedure can be used for installing PostgreSQL 9.6 on Ubuntu 16.04 LTS.
AWS Architect Online Training by Edureka

Step 1: Add PostgreSQL Apt Repository


Step 2: Install PostgreSQL


Step 3: Connecting to PostgreSQL

Ather the installation of PostgreSQL a user account called postgres created that is associated with the default Postgres role. In order log into to use Postgres account, we nee to give following command:

To list the databases  type following command

The Command above will give you following output

To list the user type following command

The Command above will give you following output

How to change PostgreSQL user password? type following command to change PostgreSQL:

To Create new user in PostgreSQL type following command:

To upgrade a user to be a superuser in PostgreSQL type following command:

We can exit PostgreSQL prompt by typing following command:

To check login info use following command



  • psql is the standard PostgreSQL application to work with databases
  • It uses a superset of standard SQL
  • It can be interactively like DBaccess, or in scripts like sqlcmd

Common psql Command Line Options

  • -A, –no-align: set output to non-aligned, no padding
  • -c sql, –command sql: execute the sql command and then exit
  • -d name, –dbname name: name of database, same as name as the first non-option argument
  • -f name, –file name: use name as the source of commands
  • -o name, –output name: put the output in name
  • -q, –quiet: suppress welcome messages
  • -t, –tuples-only: suppress print column names, result row counters, etc
  • -?, –help: get command line help

Common psql Meta-commands

  • \a: toggle output format (aligned/unaligned)
  • \c name: connect to a database name
  • \copy table: copy a table to/from a file
  • \d : list all tables (display)
  • \d table: show information about a table
  • \e: edit the query buffer
  • \g: execute the query buffer (go)
  • \h command: display help on command
  • \i name: read name into query buffer (input)

Common psql Meta-commands

  • \o name: send output to name
  • \p: display the query buffer
  • \q: quit the program
  • \r: resets (clears) the query buffer
  • \t: toggle the output headers on/off
  • \w name: write the query buffer to name
  • \! command: execute the Linux command
  • \?: help on meta-commands

Interactive psql

  • Typing in a query loads the query buffer
  • The command will not run unless terminated with a semicolon (;)
  • Meta-commands all start with blackslash (\)
  • Exit with \q

Video Instructions

Partner Sites

  • adevx5

    This installs 10+ instead of pg 9.6
    Use “apt-get install postgresql-9.6” instead

  • Lauriano Fonseca

    I installed the PhpPgAdmin and modified the connection php in order to run it in Linux 18.04 with Postgres 10.5

  • Please modify your article, your step by step does not install version 9.6!
    You make us do stupid things and waste our time !!!