How To Install postgresql on CentOS 7

In this tutorial we learn how to install postgresql on CentOS 7. postgresql is PostgreSQL client programs

Introduction

In this tutorial we learn how to install postgresql on CentOS 7.

What is postgresql

PostgreSQL is an advanced Object-Relational database management system (DBMS). The base postgresql package contains the client programs that you’ll need to access a PostgreSQL DBMS server, as well as HTML documentation for the whole system. These client programs can be located on the same machine as the PostgreSQL server, or on a remote machine that accesses a PostgreSQL server over a network connection. The PostgreSQL server can be found in the postgresql-server sub-package. PostgreSQL is an advanced Object-Relational database management system (DBMS). The base postgresql package contains the client programs that you’ll need to access a PostgreSQL DBMS server, as well as HTML documentation for the whole system. These client programs can be located on the same machine as the PostgreSQL server, or on a remote machine that accesses a PostgreSQL server over a network connection. The PostgreSQL server can be found in the postgresql-server sub-package.

We can use yum or dnf to install postgresql on CentOS 7. In this tutorial we discuss both methods but you only need to choose one of method to install postgresql.

Install postgresql on CentOS 7 Using yum

Update yum database with yum using the following command.

sudo yum makecache

After updating yum database, We can install postgresql using yum by running the following command:

sudo yum -y install postgresql

Install postgresql on CentOS 7 Using dnf

If you don’t have dnf installed you can install DNF on CentOS 7 first. Update yum database with dnf using the following command.

sudo dnf makecache

After updating yum database, We can install postgresql using dnf by running the following command:

sudo dnf -y install postgresql

How To Uninstall postgresql on CentOS 7

To uninstall only the postgresql package we can use the following command:

sudo dnf remove postgresql

References

Summary

In this tutorial we learn how to install postgresql on CentOS 7 using yum and dnf.