This article is half-done without your Comment! *** Please share your thoughts via Comment ***
PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.
I am going to share few steps to install PostgreSQL 9.6 on Ubuntu 16.04.
First, check the version of Ubuntu:
|
1 |
lsb_release -sc |
|
1 |
sudo add-apt-repository "deb https://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" |
|
1 2 |
sudo apt-get update sudo apt-get install postgresql-9.6 |
|
1 2 3 4 |
ubuntu@:~$ sudo passwd postgres Enter new UNIX password:**** Retype new UNIX password:**** passwd: password updated successfully |
|
1 |
sudo service postgresql start |
|
1 2 |
ubuntu@:~$ su postgres Password:**** |
|
1 |
createdb database_name |
|
1 |
psql -d database_name |
|
1 |
create table Test (rno integer); |
|
1 |
\q |
|
1 |
exit |
