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
service postgresql status
ReplyDelete9.3/main (port 5432): down
how to make the server running
why do you ask us for commenting while you never reply any of it !
ReplyDeleteeven if someone is asking about the content of the video!
Thanks pk your videos has really helped me. Pls I need a tutorial on how to create a cbt application in c#
ReplyDeleteThanks for the video, can you also do a video how to configure PostgreSQL with HA Pairs or 3-4 Node Cluster ?
ReplyDeleteGreat tutorial :)
ReplyDeleteYou should pronounce Postgresql as " Post-GRES-que-ell " and not like "Post-grei-SQL".
ReplyDeleteGreat video! Such a good content!
ReplyDelete