How to Install PostgreSQL in RHEL 8

PostgreSQL, also known as Postgres, 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.

In addition to being free and open-source, PostgreSQL is extremely extensible. For example, you can add your own data types, develop custom functions, even write code from various programming languages without recompiling your database!


  1. RHEL 8 with Minimal Installation
  2. RHEL 8 with RedHat Subscription Enabled
  3. RHEL 8 with Static IP Address

In this article, we will explain how to install, secure and configure PostgreSQL database management system in RHEL 8 Linux distribution.

Installing PostgreSQL Packages

1. PostgreSQL is included in the default repositories of RHEL 8, and can be installed using the following dnf command, which will install the PostgreSQL server 10, libraries and client binaries.

# dnf install @postgresql
Install PostgreSQL in RHEL 8
Install PostgreSQL in RHEL 8

Note: To install PostgreSQL 11 packages on your RHEL 8 system, you need to install the PostgreSQL RPM repository, which contains many different packages such as the PostgreSQL server, client binary, and third-party add-ons.

# dnf install
# dnf update
# dnf install postgresql11-server postgresql11  postgresql11-contrib

Initialize the PostgreSQL Database

2. Once you have installed the PostgreSQL packages, the next step is to initialize the new PostgreSQL database cluster using the /usr/bin/postgresql-setup utility, as follows.

# /usr/bin/postgresql-setup --initdb
Initialize PostgreSQL Database
Initialize PostgreSQL Database

3. Now that the PostgreSQL cluster is initialized, you need to start the PostgreSQL service, for now, then enable it to auto-start at system boot and verify its status using the systemctl command.

# systemctl start postgresql
# systemctl enable postgresql
# systemctl status postgresql
Verify PostgreSQL Installation
Verify PostgreSQL Installation

Secure and Configure PostgreSQL Database

In this section, we will show how to secure the Postgres user account and the administrative user account. Then we will cover how to configure PostgreSQL, especially how to set up client authentication.

4. Create a password for a postgres system user account using the passwd utility as follows.

# passwd postgres
Set Password for Postgres User
Set Password for Postgres User

5. Next, switch to the postgres system user account and secure the PostgreSQL administrative database user account by creating a password for it (remember to set a strong and secure password).

$ su - postgres
$ psql -c "ALTER USER postgres WITH PASSWORD 'adminpasswdhere123';"
Set PostgreSQL Admin Password
Set PostgreSQL Admin Password

6. The various PostgreSQL configuration files can be found in the /var/lib/pgsql/data/ directory. To view the directory structure, you can use the tree (install it using dnf install tree) command.

# tree -L 1 /var/lib/pgsql/data/
PostgreSQL Configuration Files
PostgreSQL Configuration Files

The main server configuration file is /var/lib/pgsql/data/postgresql.conf. And the client authentication can be configured using the /var/lib/pgsql/data/pg_hba.conf.

7. Next, let’s look at how to configure client authentication. PostgreSQL database system supports different types of authentication including password-based authentication. Under the password-based authentication, you can use one of the following methods: md5, crypt, or password (sends the password in clear-text).

Although the above password-authentication methods work in a similar way, the major difference between them is: which way a user’s password is stored (on the server) and sent across the connection, when entered by a user.

To prevent password sniffing by attackers and avoid storing passwords on the server in plain text, it is recommended to use md5 as shown. Now open the client authentication configuration file.

# vi /var/lib/pgsql/data/pg_hba.conf

And look for the following lines and change the authentication method to md5.

host    all             all               md5
host    all             all		::1/128                 md5
Configure PostgreSQL Password Authentication
Configure PostgreSQL Password Authentication

8. Now restart the Postgres service to apply the recent changes in the configuration.

# systemctl reload postgresql

9. At this stage, your PostgreSQL database server installation is now secure. You can switch to the postgres account and start working with PostgreSQL.

# su - postgres
$ psql

You can read the official PostgreSQL documentation (remember to select docs for the version you have installed) to understand how PostgreSQL works and how to use it for developing applications.

That’s all for now! In this guide, we have shown how to install, secure and configure PostgreSQL database management system in RHEL 8. Remember you can give us feedback via the feedback form below.

Aaron Kili
Aaron Kili is a Linux and F.O.S.S enthusiast, an upcoming Linux SysAdmin, web developer, and currently a content creator for TecMint who loves working with computers and strongly believes in sharing knowledge.

Each tutorial at TecMint is created by a team of experienced Linux system administrators so that it meets our high-quality standards.

Join the TecMint Weekly Newsletter (More Than 156,129 Linux Enthusiasts Have Subscribed)
Was this article helpful? Please add a comment or buy me a coffee to show your appreciation.

Got something to say? Join the discussion.

Thank you for taking the time to share your thoughts with us. We appreciate your decision to leave a comment and value your contribution to the discussion. It's important to note that we moderate all comments in accordance with our comment policy to ensure a respectful and constructive conversation.

Rest assured that your email address will remain private and will not be published or shared with anyone. We prioritize the privacy and security of our users.