In this tutorial, we will see how to install PostgreSQL 9.6 on Ubuntu 16.04 LTS. The same procedure can be used to install 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: Connect to PostgreSQL
After installing PostgreSQL, a user account called postgres was created and associated with the default Postgres role. To log in and use the Postgres account, we need to give the following command:
sudo su-postgres
psql
Best Online ProgrammingKnowledge Courses
Python programming course ️ http://bit.ly/2vsuMaS ️ http://bit.ly/2GOaeQB
Java programming course ️ http://bit.ly/2GEfQMf ️ http://bit.ly/2Vvjy4a
Bash Shell Scripting Course ️ http://bit.ly/2DBVF0C ️ http://bit.ly/2UM06vF
Linux Command Line Tutorials ️ http://bit.ly/2IXuil0 ️ http://bit.ly/2IXukt8
C programming course ️ http://bit.ly/2GQCiD1 ️ http://bit.ly/2ZGN6ej
C programming course ️ http://bit.ly/2V4oEVJ ️ http://bit.ly/2XMvqMs
PHP programming course ️ http://bit.ly/2XP71WH ️ http://bit.ly/2vs3od6
Android development course ️ http://bit.ly/2UHih5H ️ http://bit.ly/2IMhVci
C# programming course ️ http://bit.ly/2Vr7HEl ️ http://bit.ly/2W6RXTU
JavaFx programming course ️ http://bit.ly/2XMvZWA ️ http://bit.ly/2V2CoAi
NodeJs programming course ️ http://bit.ly/2GPg7gA ️ http://bit.ly/2GQYTQ2
Jenkins Course for Developers and DevOps ️ http://bit.ly/2Wd4l4W ️ http://bit.ly/2J1B1ug
Scala Programming Tutorial Course ️ http://bit.ly/2PysyA4 ️ http://bit.ly/2PCaVj2
Bootstrap Responsive Web Design Tutorial ️ http://bit.ly/2DFQ2yC ️ http://bit.ly/2VoJWwH
MongoDB Tutorial Course ️ http://bit.ly/2LaCJfP ️ http://bit.ly/2WaI7Ap
QT C GUI tutorial for beginners ️ http://bit.ly/2vwqHSZ
Online courses to learn
Get 2 months FREE of unlimited lessons from Skillshare – https://skillshare.eqcm.net/r1KEj
Data Science – http://bit.ly/2lD9h5L http://bit.ly/2lI8wIl
Machine learning – http://bit.ly/2WGGQpb http://bit.ly/2GghLXX
Artificial intelligence – http://bit.ly/2lYqaYx http://bit.ly/2NmaPya
MERN Stack E-Degree Program – http://bit.ly/2kx2NFe http://bit.ly/2lWj4no
DevOps e-diploma – http://bit.ly/2k1PwUQ http://bit.ly/2k8Ypfy
Data analysis with R – http://bit.ly/2lBKqz8 http://bit.ly/2lAjos3
AWS Certification Training – http://bit.ly/2kmLtTu http://bit.ly/2lAkQL1
Projects in Java – http://bit.ly/2kzn25d http://bit.ly/2lBMffs
Machine learning with TensorFlow – http://bit.ly/2m1z3AF http://bit.ly/2lBMhnA
Angular 8 – Complete Essential Guide – http://bit.ly/2lYvYRP
Android Kotlin development masterclass – http://bit.ly/2GcblsI
Learn iOS programming by creating advanced projects – http://bit.ly/2kyX7ue
Follow
My website – http://www.codebind.com
DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I will receive a small commission. This helps support the channel and allows us to continue making videos like this. Thank you for your support!
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments