PostgreSQL: How to Install PostgreSQL 9.4 on Ubuntu 14.04?

PostgreSQL Elephant


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.4 on Ubuntu 14.04.

First, check the version of Ubuntu:

You need to add the latest PostgreSQL repository for the latest version, otherwise It will install PostgreSQL 9.3. This is for trusty version.
Update and Install PostgreSQL 9.4:
Default postgres super user and postgres database is created. You need to set a password for the postgres super user.
If service is not started, you can start the PostgreSQL service.
Connect PostgreSQL server using postgres user:
Create a sample database:
Connect to that database:
Create a sample table:
Exit to database session:
Exit to PostgreSQL server:
Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of