Install PostgreSQL 12 on BOSS8 (Bharat Operating System Solutions)

Bharat Operating System Solutions (BOSS GNU/Linux) is an Indian Linux distribution derived from Debian. BOSS Linux is officially released in four editions: BOSS Desktop (for personal use, home and office), EduBOSS (for schools and education community), BOSS Advanced Server and BOSS MOOL. The latest stable version 8.0 ("Unnati"), was released on 15 October 2019.

It is developed by Centre for Development of Advanced Computing (C-DAC) in order for enhancing and gain benefit from the usage of Free and Open Source Software throughout India. BOSS Linux is a key deliverable of National Resource Centre for Free and Open Source Software (NRC-FOSS). It has enhanced desktop environment integrated with Indian language support and other software.

https://en.wikipedia.org/wiki/Bharat_Operating_System_Solutions

PostgreSQL is included in the official BOSS repositories, but not in version 12 but in version 11.

Install PostgreSQL 12 on BOSS8

Step1: Update System

BOSS8 derived from Debian. So first we find DEBIAN VERSION with below commands

cat /etc/debian_version

Its show BOSS8 DEBIAN version 10.5

It is recommended to update current system packages if it is a new server instance.

sudo apt update

sudo apt -y upgrade

sudo shutdown -r now

Step 2: Add PostgreSQL 12 repository

First, open a terminal session or connect to your server using SSH. Then, install some necessary packages:

sudo apt install gnupg gnupg2

At the end, the PostgreSQL 12 repository should be added to the list of BOSS software sources. To do this, create the following file:

sudo nano /etc/apt/sources.list.d/pgdg.list

And in it please adds the following:

deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main

It looks like below:

Then save the changes by pressing CTRL + O and close the file by pressing CTRL + X.

For the repository to be accepted by the system, we need to add the gpg key to it. To do this, use

the following command:

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add –

Once the process has been completed, simply update the APT cache.

sudo apt update

Check Postgresql package

Sudo apt list postgresql-12 

It looks like below

Step 3: Install PostgreSQL 12 on BOSS8

sudo apt install postgresql-12

sudo systemctl status postgresql

sudo systemctl enable postgresql

Step 4: Test PostgreSQL Connection

sudo su - postgres

psql

Change postgres user password

Alter user postgres with password ‘abc’;