pgAdmin4

pgAdmin 4 v9.14 is a powerful open-source web-based administration and development platform for PostgreSQL databases. It enables database administrators and developers to manage PostgreSQL servers, execute SQL queries, monitor database activity, and configure database objects through an intuitive graphical interface.

The solution supports common PostgreSQL administration workflows including database management, query execution, user and role management, backup and restore operations, server monitoring, and secure remote access. It is ideal for database administration, development environments, analytics workloads, and enterprise PostgreSQL management.

Features of pgAdmin 4 v9.14:

• Web-based interface for PostgreSQL database administration.
• SQL query tool with syntax highlighting and execution history.
• Database object management including schemas, tables, indexes, and functions.
• User and role management with privilege configuration.
• Backup and restore support for PostgreSQL databases.
• Server monitoring and session/activity statistics.
• Supports multiple PostgreSQL server connections.
• Secure web access with optional HTTPS configuration.

Installation Instructions for pgAdmin 4 v9.14
$ sudo su
$ apt update && apt upgrade -y
$ apt install -y curl gnupg2 ca-certificates lsb-release
$ curl -fsS https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /usr/share/keyrings/packages-pgadmin-org.gpg
$ echo "deb [signed-by=/usr/share/keyrings/packages-pgadmin-org.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" | sudo tee /etc/apt/sources.list.d/pgadmin4.list
$ apt update
$ apt install -y pgadmin4-web=9.14*
$ /usr/pgadmin4/bin/setup-web.sh

Check Installed Version
$ dpkg -l | grep pgadmin4
OR
$ /usr/pgadmin4/bin/pgadmin4 --version

Usage Instructions for pgAdmin 4
$ sudo systemctl status apache2
$ sudo systemctl restart apache2

Credentials are created during setup-web configuration.

Access the pgAdmin Dashboard:
Open your browser and navigate to:
http://your-server-ip/pgadmin4

Default Ports:

• HTTP: 80
• HTTPS: 443
• PostgreSQL: 5432

Disclaimer: pgAdmin 4 is provided “as is” under applicable open-source licenses. Users are responsible for secure PostgreSQL configuration, database backups, access control management, and protecting sensitive data. This solution is best suited for PostgreSQL database administration, monitoring, development, and production management environments.