How to Install PostgreSQL on CentOS 8

Install PostgreSQL on CentOS 8

In this article, we will have explained the necessary steps to install and configure PostgreSQL on CentOS 8. Before continuing with this tutorial, make sure you are logged in as a user with sudo privileges. All the commands in this tutorial should be run as a non-root user.

PostgreSQL is a powerful, open-source object-relational database management system that uses and expands the SQL language combined with numerous features that safely keep and scale the most complex data workloads.

PostgreSQL ships with the number of features intended to help programmers to develop applications, administrators to safeguard data integrity and create fault-tolerant environments, and assist you to manage your data no matter how large or small the dataset

Install PostgreSQL on CentOS

Step 1. The first command will update the package lists to ensure you get the latest version and dependencies.

Step 2. Install PostgreSQL.

PostgreSQL is included in the default repositories of CentOS 8, and can be installed using the following dnf command:

Once the installation is done, you can initialize the database using the below command:

To start and enable PostgreSQL you need to use the systemctl command:

Step 4. Create PostgreSQL Database and Role.

  • Create a new PostgreSQL Role The following command will create a new role named ramona:
  • Create a new PostgreSQL DatabaseCreate a new database named ramona using the createdb command:
  • Grant privilegesTo grant permissions to the ramona user on the database we created in the previous step, connect to the PostgreSQL shell:

    and run the following query:

Step 5. Enable remote access to PostgreSQL server.

Use the following steps to enable remote access to the PostgreSQL server:

Update listen_addresses like given below:

Now restart the PostgreSQL service with systemctl command:

Verify the changes with the ss utility:

Finally update pg_hba.conf file to configure server remote connections using below examples:

Congratulation, you have learned how to install and configure PostgreSQL on CentOS 8. If you have any question, please leave a comment below.