Skip to main content

How to Install and configuration PostgreSQL on Ubuntu Linux - Learn Online

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 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:

$ sudo su - postgres
$ psql


  1. service postgresql status
    9.3/main (port 5432): down

    how to make the server running

  2. why do you ask us for commenting while you never reply any of it !
    even if someone is asking about the content of the video!

  3. obileye oladotun1 March 2017 at 15:44

    Thanks pk your videos has really helped me. Pls I need a tutorial on how to create a cbt application in c#

  4. Thanks for the video, can you also do a video how to configure PostgreSQL with HA Pairs or 3-4 Node Cluster ?

  5. Tech and Programming1 March 2017 at 15:44

    Great tutorial :)

  6. You should pronounce Postgresql as " Post-GRES-que-ell " and not like "Post-grei-SQL".

  7. Angry KoalaBear1 March 2017 at 15:44

    Great video! Such a good content!


Post a Comment

Popular posts from this blog

C++ Programming Tutorial - How to Install Code::Blocks in Ubuntu Linux - Learn Online

Installing Code::Blocks How do I Install Code::Blocks HOWTO: Installing Code::Blocks 10.05 How do you install Irrlicht on Code::Blocks? How do you install CodeBlock on ubuntu? codeblocks /bin/sh: g++: not found Installing codeblocks on ubuntu Installing Code::Blocks on Ubuntu 10.04?

Google Fight Against Low Quality and Spammy Content

  Google's ongoing battle against spammy and low-quality content in search results is an essential aspect of maintaining the platform's credibility and usefulness. Here are some of the new strategies and policies Google is implementing to combat these issues: Improved Quality Ranking : Google is enhancing its core ranking algorithms to prioritize high-quality and original content while reducing the visibility of unoriginal or spammy content in search results. New Spam Policies : Google is updating its spam policies to address emerging tactics used by spammers. This includes targeting practices such as expired websites repurposed as spam repositories, obituary spam, and other manipulative behaviors. Reducing Unoriginal Results : Google is refining its ranking systems to identify and minimize unhelpful, unoriginal content. This includes pages created specifically to match certain search queries and content that prioritizes search engine optimization over user experience. Scaled C

Beginners MYSQL Database Tutorial # How to install MySQL on Ubuntu/Debian Linux - Learn Online

Installing and Using Mysql on Ubuntu How to install mysql install mysql on ubuntu Searches related to Installing and Using MySQL in Ubuntu installing mysql on ubuntu server installing mysql workbench on ubuntu Installing MySQL Server on Ubuntu Searches related to Installing and Using MySQL server in Ubuntu setting up mysql server ubuntu setting up mysql server linux installing php ubuntu server installing apache ubuntu server installing phpmyadmin ubuntu server installing mysql debian where does mysql install on linux ubuntu install php mysql Ubuntu Linux Install MySQL Server installing mysql 5.5 on ubuntu installing mysql gem ubuntu installing mysql client on ubuntu installing php mysql ubuntu installing apache on ubuntu installing php ubuntu