How to setup pgAdmin 4 on RHEL 9

pgAdmin is an open-source administration and management tool for PostgreSQL, one of the most popular relational database management systems. It provides a graphical user interface (GUI) to help database administrators and developers interact with PostgreSQL databases more easily.

Key Features of pgAdmin:

• User-friendly GUI: Manage databases, execute SQL queries, and browse schemas without using the command line.
• Query Tool: Allows users to write and execute SQL queries with syntax highlighting.
• Database Administration: Manage users, roles, tables, and other database objects.
• Backup & Restore: Perform database backups and restore data efficiently.
• Monitoring Tools: View running queries, server logs, and performance metrics.
• Cross-Platform Support: Works on Windows, Linux, and macOS.

Install Pgadmin4, first we need external repository

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

To install pgAdmin, run one of the following commands:

# yum install pgadmin4

Finally, if you have installed pgadmin4, run the web setup script to configure
the system to run in web mode:

# sudo /usr/pgadmin4/bin/setup-web.sh

To access pgadmin4, launch your browser and browse the URL shown.

# http://server-ip/pgadmin4
# http://192.168.1.25/pgadmin4

After Login show the dashboard