How to Install PostgreSQL on Linux Mint 20

To Install PostgreSQL on Linux Mint 20

Introduction:

PostgreSQL is the most advanced, powerful open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. This tutorial will cover the installation of PostgreSQL on Linux Mint 20. Installation Procedure: First I am check the version of my linux mint version by using following command

root@LinuxHelp:~# lsb_release -a
No LSB modules are available.
Distributor ID:	Linuxmint
Description:	Linux Mint 20
Release:	20
Codename:	ulyana

Now I am import the GPG key of PostgresSQL by using following command

root@LinuxHelp:~# wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
OK

Now I am add the postgres repository by using following command

root@LinuxHelp:~# sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'

Now I am install postgresSQL by using following command

root@LinuxHelp:~# apt install postgresql postgresql-contrib -y
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following additional packages will be installed:
  libllvm10 libpq5 postgresql-12 postgresql-client-12 postgresql-client-common
  postgresql-common sysstat
Suggested packages:
.
.
Processing triggers for systemd (245.4-4ubuntu3) ...
Processing triggers for man-db (2.9.1-1) ...
Processing triggers for doc-base (0.10.9) ...
Processing 1 added doc-base file...

Now I am switch the postgres user by using following command

root@LinuxHelp:~# su postgres

Now I am check the version of the postgres by using following command

postgres@LinuxHelp:~$ psql
psql (12.5 (Ubuntu 12.5-0ubuntu0.20.04.1))
Type "help" for help.

Now I am view the information of the postgres database by using following command

postgres=# \conninfo

You are connected to database "postgres" as user "postgres" via socket in "/var/run/postgresql" at port "5432".

Now I am exit from the postgres shell

postgres=# exit

now I am check the listening port of postgres by using following command

postgres@LinuxHelp:~$ ss -atulpn | grep postgres
tcp     LISTEN   0        244            127.0.0.1:5432           0.0.0.0:*      users:(("postgres",pid=5592,fd=3))  

With this method the installation of the PostgreSQl on Linux Mint 20 is comes to an end.