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


Comments

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

    how to make the server running

    ReplyDelete
  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!

    ReplyDelete
  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#

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

    ReplyDelete
  5. Tech and Programming1 March 2017 at 15:44

    Great tutorial :)

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

    ReplyDelete
  7. Angry KoalaBear1 March 2017 at 15:44

    Great video! Such a good content!

    ReplyDelete

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?

Eyeglasses and Lenses Prescription WooCommerce Wordpress Best Plugin

WooCommerce EYE Glasses and Lenses Prescription Wordpress Plugin builds your Eye Glasses and Lenses Website quickly and easily. It is powered by WooCommerce and it is fully automated so you don’t need to do anything. It features popular Presciption, Select Lenses and their Addons. You can also easily increase your sale by adding your this plugin. prescription glasses is the best plugin for your wordpress website. its Tested in All major Themeforest Wordpress & WooCommerce theme, Features Suits on every type of Eyeglasses and Lenses prescription Have multiple lens options  Compatible with Wordpress & WooCommerce  Anti Reflective Option  Sphere Select Option  Cylinder Select Option  Axis Select Option  Add Select Option  Pupils Distance Select Option Download

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