Home Linux How to Install PostgreSQL Database and pgAdmin on Linux

How to Install PostgreSQL Database and pgAdmin on Linux

Installation of the PostgreSQL database is the first step to move one step ahead towards the open source world of the database. pgAdmin and PostgreSQL are both interconnected with each other by the core system of which is installed inside the machine.

PostgreSQL database is an open-source and object-relational database system. PostgreSQL has a graphical user interface (GUI) admin control for the database management named pgAdmin. pgAdmin is a design and management interface for the PostgreSQL database. Simple database, datasheets, and operations can be done with pgAdmin by interacting with the local filesystem of the database allowed by the user.

PostgreSQL Database


Structured Query Language (SQL) is a programming language that is used to analyze, manage, and maintain a database. SQL can do join, union, insert between two or more databases. Some database engines are used to do the database program. They are Oracle, MySQL, Microsoft SQL Server, PostgreSQL, MongoDB, IBM DB2, etc.

Among the above database engines (DB engine), PostgreSQL is the most user-friendly and open source based free database engine. PostgreSQL is also simply known as Postgres. Postgres is a free Relational Database Management System (RDBS), which can be used to maintain a variety of workloads. Postgres can handle single machines to data warehouses or Web services with many concurrent users.

In this post, we are going to learn how to install PostgreSQL and pgAdmin in Ubuntu as well as in all other Linux distributions.

Step 1: Installation of PostgreSQL Database


PostgreSQL database is an open-source application. So it is available on the web, which is free to use. No subscription fee is charged to purchase PostgreSQL. In Linux, PostgreSQL can be installed with the apt packaging system. So, to install the PostgreSQL database, the following command lines will be run in the terminal.

sudo apt-get update
sudo apt install postgresql postgresql-contrib

installation of postgresql in ubuntu

Here at the end of the second line of the command, you can see that there is a contrib, which means that as you are using Postgres for the first time, this will download and install all the additional required files in your system. Once your terminal is in action, you will see a progress bar below in your terminal, showing how many percentages of installation are done.

progress install postgres database

So now, PostgreSQL is installed successfully inside your machine or system.

Step 2: Installation of pgAdmin for PostgreSQL


As it is mentioned earlier that pgAdmin is the control unit of PostgreSQL, so pgAdmin must have been installed properly to run the database engine. The pgAdmin3 is already available in Ubuntu Software Store. You just need to type and search pgAdmin inside the software store. You will find pgAdmin3 there, and there you go, install it with your system administrative password.

pgAdmin in linux for postgreSQL database

Step 3: Changing the Master Password of pgAdmin3


In the PostgreSQL database, pgAdmin always comes with prelocked with a master password for the purpose of data encryption and the safety of the database. To use pgAdmin3 inside PostgreSQL, you have to change the master password of pgAdmin3. For that, at this stage of the installation process, you have to open the terminal in your system and type the following command lines in the terminal given below. This terminal commands will reach you towards the stage of changing the password of pgAdmin in PostgreSQL.

sudo -u postgres psql postgres
 \password postgres

Now you have to assign your new password and type one more time for security purposes. There you go, Now you have full control over your database engine. 

Creating a New Database in PostgreSQL


After the installation process is done, it is time to create a new database and test it. Before we start, let me tell you that PostgreSQL works with the interface of a web browser. So when you create your database in pgAdmin and you may see the output opening in your web browser. Now open pgAdmin3, and you will find a New Server button right in the upper row. Click on ‘Add Server’ it will show you a dialog box. This box is the setting function for your database server.

The settings will be as given below:

server of postgreSQL database in linux

Name: Name of your database
Host: localhost
Port: 5432
Maintenance DB: postgres
Username: postgres
Password: Password that you have changed earlier with terminal.
Group: Servers

If everything is done, click Ok, it will open a new pop-up window ensuring that you have changed the pgAdmin3 password, click Ok again.

Here you are almost done, your IDE is ready to be programmed now. To open the SQL IDE, just click on the SQL button. It will open another window where you will be able to write your first program. Here for explanation purpose, I have written a simple SQL program of coffee name with order table using join command.

install PostgreSQL database

Enjoy your free and open source database engine, PostgreSQL pgAdmin.

Finishing Touch


Here you are at the very ending of this post. In this post, we have discussed the installation process of the PostgreSQL database and pgAdmin in Linux. As a relational database management system, the PostgreSQL database is the most popular and reliable nowadays.

If you have anything to ask related to this post, please feel free to type in the comment section. And don’t forget to share this tutorial with your friends in your social network.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest Post

The 20 Best Python Tips and Tricks You Must Know in 2020

Python programming language is still experiencing incredible growth. GitHub, home of over forty million developers, publishes a yearly report...

40 Practical and Useful awk Command in Linux and BSD

AWK is a powerful data-driven programming language that dates its origin back to the early days of Unix. It...

The 20 Best Web Browsers for Android Devices in 2020

As a regular user of the internet, you must be familiar with many Web browsers for Android devices. Now...

How to Install and Use Docker in Your Linux System

Docker is an open-source platform for Linux system administrators and developers where you can build and run programs using...

Most Talked Post

Linux or Windows: 25 Things You Must Know While Choosing The Best Platform

Choosing the best platform - Linux or Windows is complicated. Because both the system is versatile and capable of...

Most Stable Linux Distros: 5 versions of Linux We Recommend

At the very beginning, I would like to mention why the term ‘Stable’ comes in relation to Linux OS...

15 Best Things To Do After Installing Linux Mint 19 “Tara”

Linux Mint is one of the best Linux distros for newcomers, especially who comes from other Operating Systems like...

Linux Mint vs Ubuntu: 15 Facts To Know Before Choosing The Best One

Ubuntu and Linux Mint are two popular Linux distros available in the Linux community. Ubuntu is a derivative of...

Editors' Pick

Best Linux Gaming Distros: 5 Shortlisted Recommendation

There was a time when better gaming experience was...

The 20 Best Python Tips and Tricks You Must Know in 2020

Python programming language is still experiencing incredible growth. GitHub,...

Top 12 Best Google Drive Linux Client Software in 2020

Google Drive is one of the best Cloud Storage...

Everything You Need To Know About the Linux File System

Files and their manipulation lie at the center of...

Top 20 Best Bioinformatics Tools for Linux: An Ultimate Collection

There are far-ranges of Linux bioinformatics tools available that...