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


Labels:

Comments

  1. C .R. Anil1 March 2017 at 15:44

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

    how to make the server running

    ReplyDelete
  2. Ahmed Tammaa1 March 2017 at 15:44

    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. its Enki1 March 2017 at 15:44

    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. Sam Vs Code1 March 2017 at 15:44

    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?
27 comments
Read more

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
Post a Comment
Read more

Contextual Design and Development is the Driving Force Behind all Successful Mobile Applications

The time of ordinary custom web application design & development is long gone. Today the focus is on contextual design and development. It is the rise in the popularity of mobile applications that has provided the impetus for giving importance to ‘context’ when it comes to app or web development. Let’s focus our attention on mobile applications and why mobile applications need to be developed keeping the context in mind. Because they are used in diverse locations Let’s face it. We all love mobile apps because they can be used just about anywhere and at any given point of time. Yes, that’s right, they can be used in offices, on a train, in the kitchen, movie theatre and the list just goes on. So, the app needs to be developed in context of the location. Different users have different needs when it comes to a mobile app and these needs, in part, are determined by their location. For e.g. if a developer thinks a particular app that is in the process of being developed will onl
1 comment
Read more