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…
i am getting an error in installing postgresQL is it is unable to install postgresql-common package. what should i do?
thank you! it was so helpful!
Good introduction. It all worked on my Lubuntu machine, too. Thanks.
it works thank you
Great video on how to set it up! Really appreciated. Beats doing it all on your own for sure!!
con notable to login using user_1 tellin 3 times password incorrect test123
very useful video for fresher thanks for making this video
Thank you 🙂
This is helpful. Thank you so much !
Excellent video, it explains all what i needed to know
Thankz and this is work
very helpful
Great video. Thank you!
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?
remember to use "postgres" when type alter user postgres with password 'yourpass'
it is really useful,thanks
nice vedio.. helped a lot
this is very very helpful. thanks man!
nice introduction!
I agree that PostgreSQL is way better, but "MySQL did not have triggers"… are you sure ?
Very good short & clear Thank you
Very good. Thanks :))))
Please help..i want to learn how to install postgres and jboss on red hat linux server. I am not able to find any video.
Hey thanks a lot. Big help!!
thank you so much, this was very helpfull
service postgresql status
9.3/main (port 5432): down
how to make the server running
Thanks pk your videos has really helped me. Pls I need a tutorial on how to create a cbt application in c#
Great tutorial 🙂
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!
You should pronounce Postgresql as " Post-GRES-que-ell " and not like "Post-grei-SQL".
Thanks for the video, can you also do a video how to configure PostgreSQL with HA Pairs or 3-4 Node Cluster ?
Great video! Such a good content!