How to Install and configuration PostgreSQL on Ubuntu Linux

Video is ready, Click Here to View ×


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 16.04 LTS. The same procedure can be used for installing PostgreSQL 9.6 on Ubuntu 14.04 LTS.

Step 1: Install PostgreSQL

$ sudo apt-get update
$ sudo apt-get install postgresql postgresql-contrib

Step 2: Connecting to PostgreSQL

Ather the…

32 Comments

  1. I am a complete newbie to linux ubuntu and wonder if someone could help me with the following problem. I have Ubuntu on my laptop as a dual boot with windows 10. I have Postgresql installed on my windows partition. I now want to install it on my Ubuntu partition.

    After I put in the command "sudo apt-get update" I am asked for my password. After I type it in I get the following message unlike in the video:

    Err:1 http://nz.archive.ubuntu.com/ubuntu xenial InRelease
    Temporary failure resolving 'nz.archive.ubuntu.com'
    Err:2 http://security.ubuntu.com/ubuntu xenial-security InRelease
    Temporary failure resolving 'security.ubuntu.com
    Err:3 http://nz.archive.ubuntu.com/ubuntu xenial-updates InRelease
    Temporary failure resolving 'nz.archive.ubuntu.com'
    Err:4 http://nz.archive.ubuntu.com/ubuntu xenial-backports InRelease
    Temporary failure resolving 'nz.archive.ubuntu.com
    Reading Package Lists…..Done
    W: Failed to fetch http://nz.archive.ubuntu.com/ubuntu/dists/xenial/InRelease Temporary failure resolving 'nz.archive.ubuntu.com'
    W: Failed to fetch http://nz.archive.ubuntu.com/ubuntu/dists/xenial-updates/InRelease Temporary failure resolving 'nz.archive.ubuntu.com'
    W: Failed to fetch http://nz.archive.ubuntu.com/ubuntu/dists/xenial-backports/InRelease Temporary failure resolving 'nz.archive.ubuntu.com'
    W: Failed to fetch http://security.ubuntu.com/ubuntu/dists/xenial-security/InRelease Temporary failure resolving 'nz.archive.ubuntu.com'
    W: Some index files failed to download. They have been ignored or old ones used instead.

    What does this mean and why do I get these error messages?

Leave a Reply

Your email address will not be published.


*