Module 1: Installation of PostgreSQL on Linux Server

In this blog, I will discuss how to install and configure PostgreSQL on Ubuntu System.

The list of tasks:

• Installation procedure of PostgreSQL for Ubuntu

Installation Procedure of PostgreSQL for Ubuntu:

Step 1: Login your Ubuntu Server to install PostgreSQL

First you need to update the system using sudo apt-get update command

Step 2: install the PostgreSQL using the following command. I am going to install PostgrSQL 9.6

Step 3: Now you can see the PostgreSQL configuration files using ls /etc/postgresql/9.6/main [version can be differ] 

Step 4: The default user for the PostgreSQL is postgres. Postgres is also known as root or super user. login the PostgreSQL using postgres user by sudo su postgres

Step 5 : Login the psql command prompt …….. type : psql

you can see the postgres user psql command prompt in where you can execute sql query to create and manage databases, users, schema, and db objects.

Step 6: \l – will show you the list of databases

\du – will show you the list of users in the PostgreSQL database

Thank you 🙂