pgAdmin 4 app (v9.13) Innovation Release
This documentation covers the current Innovation Release of
EDB Postgres AI. See also:
- Hybrid Manager dual release strategy
- Documentation for the current Long-term support release
Important
Regular upstream releases deliver security updates. Keep your pgAdmin instance up to date to receive the latest patches.
pgAdmin 4 is an open-source web-based interface for administering PostgreSQL databases. When deployed as an app in Hybrid Manager, it provides remote access to your PostgreSQL clusters for managing database objects and executing queries.
Warning
pgAdmin 4 isn't supported on Red Hat OpenShift (RHOS).
Key features
- Graphical interface for managing PostgreSQL database objects.
- Query tool with syntax highlighting, query history, and execution plan visualization.
- Server monitoring including statistics, logs, and activity.
- Backup and restore tools.
- Schema, role, and permission management.
Requirements
Technical requirements
- Kubernetes cluster.
- Persistent volume: 10Gi (default) for data storage.
- Resources: Minimum 512Mi memory, 500m CPU (limits: 1Gi memory, 1000m CPU).
Supported PostgreSQL versions
- PostgreSQL 13 to 18.
- EDB Advanced Server: 13 to 18.
Deploying pgAdmin 4
- In the HM console, navigate to Asset Library, then select Apps.
- Select pgAdmin 4, select the version, and select Deploy.
- Under Identity, enter a name for your deployment and select the target project.
- Configure the replica count (default:
1) and storage size if needed. - Select Deploy.
Note
Once you have deployed pgAdmin 4 in HM, you can access it in the HM console under Apps or Asset Library.
Post-deployment configuration
Once pgAdmin 4 is deployed, complete these steps to finish your setup:
- Navigate to your Project and select the Apps tab, or navigate to Estate > Apps to check the deployment status. When the status shows Ready, launch the app to continue.
- Open pgAdmin 4 from the HM console.
- Set the master password.
- Register your PostgreSQL servers within the pgAdmin interface to begin managing your databases.
Support resources
As pgAdmin OSS is community-supported, use these resources for technical guidance and updates:
- pgAdmin support page — get support for any queries related to pgAdmin 4.
- pgAdmin documentation — self-service deployment and feature guides, as well as additional information on pgAdmin installation and configuration.
- pgAdmin GitHub repository — source code, issue tracker, and release notes.