Install Postgresql on Ubuntu 16

Installation Postgresql on Ubuntu 16:

Date Posted: 21-07-2017

Postgresql is a database server which is similar to mysql. In this post, we will explain on how to install postgresql on ubuntu host

Prerequisites:

1. Ubuntu Host with root access.

Implementation:

Perform the update on the server

apt-get update

Install the postgresql and postgresql-contrib package.

apt-get install postgresql postgresql-contrib

Enable postgesql service on reboot safe.

systemctl enable postgresql

Start the postgresql server.

systemctl start postgresql

To access postgresql, use the below command.

sudo -u postgresql psql

To exit from postgresql prompt,

\q