Step‑by‑Step: Install PostgreSQL 12 and pgAdmin4 on RHEL 8

PgAdmin4 is an open‑source, web‑based management tool for PostgreSQL, built with Python Flask and a modern HTML5/CSS3/Bootstrap front‑end. It rewrites the original C++ PgAdmin 3 and offers features such as a polished UI, responsive layout, real‑time SQL editor with syntax highlighting, powerful dialogs, helpful tips, and more.

PgAdmin4 Features

Elegant web UI with icons and panels

Responsive layout with dashboard for real‑time monitoring

SQL query tool/editor with syntax highlighting

Robust management dialogs and common task utilities

Helpful tips for getting started

Additional features

In this article you will learn how to install PostgreSQL and pgAdmin4 on RHEL 8 using the WSGI module in server mode, with Apache as the backend web server.

Installing PostgreSQL on RHEL 8

First, list the available PostgreSQL modules: # dnf module list postgresql Enable the desired module (PostgreSQL 12) and install the server package:

# dnf module enable postgresql:12

# dnf install postgresql-server

Initialize the database cluster: # postgresql-setup --initdb Start and enable the PostgreSQL service:

# systemctl start postgresql
# systemctl enable postgresql

Verify that the service is running:

# systemctl status postgresql

Installing pgAdmin4 on RHEL 8

Add the external pgAdmin repository:

# rpm -i https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/pgadmin4-redhat-repo-1-1.noarch.rpm

Install pgAdmin4 in server mode: # dnf install pgadmin4-web Install the SELinux utilities required for the setup: # sudo dnf install policycoreutils-python-utils Run the pgAdmin4 setup script, which creates the pgadmin user, directories, configures SELinux, and starts Apache: # /usr/pgadmin4/bin/setup-web.sh Open firewall port 80 for web traffic and reload the firewall:

# firewall-cmd --add-port=80/tcp --permanent
# firewall-cmd --reload

Allow Apache to make network connections via SELinux: # setsebool -P httpd_can_network_connect 1 Access pgAdmin4 by opening a browser and navigating to the displayed URL (e.g., http://server-ip/pgadmin4) and log in with the email and password you set during the setup script.

After logging in, you will be taken to the pgAdmin4 dashboard where you can create and manage PostgreSQL databases and monitor performance using the provided tools.