$ sudo yum -y install epel-release yum-utils You can add the -contrib package along with the installation command to add additional functionalities and features to your PostgreSQL.

To install the PostgreSQL 12 on CentOS, run the following commands.įirst, you need to enable the PostgreSQL repository on CentOS by running the following command.Īfter installation, you can check the information about the installed package by running the following command.Īfter enabling the PostgreSQL repository, run the following command to install PostgreSQL 12 on CentOS 7 and 8. Install PostgreSQL 12 version on CentOS from PostgreSQL repository The psql utility in a command helps to interact with the PostgreSQL database easily. $ sudo -u postgres psql -c “SELECT version() ” To check the PostgresSQL version and confirm installation, run the following command. Run the following commands to start and enable PostgreSQL service. $ sudo yum install postgresql postgresql-contribĪfter the installation, you need to initialize the PostgreSQL database by running the following command.Īfter initializing the database, you need to start the PostgreSQL service and then enable it to make sure that the service starts up during the system boot-up. The -contrib package adds additional functionality and features to the installed PostgreSQL. You can install PostgreSQL on the CentOS repository by running the following command with -contrib package. Install PostgreSQL on CentOS from CentOS repository

You should log in as a non-root user and have sudo privileges as the prerequisites. In this tutorial, you learn how to install PostgreSQL on CentOS from the CentOS repository and PostgreSQL repository.

PostgreSQL answers the structured query language similar to MySQL. PostgreSQL provides an implementation of the SQL querying language, and it is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. PostgreSQL is also known as Postgres, and it is a free, powerful, and open-source relational database management system. Configure and Install PostgreSQL on CentOS 7 and 8

Install postgresql centos 7