# PgAdmin 4

PgAdmin 4 is a web-based administration tool for the PostgreSQL database. It is open source and self-hosted, installable on TrueNAS, Docker Hub, Kubernetes (Helm) and Unraid.

Canonical page: https://ourlocalhost.com/app/317/pgadmin-4

## Description

pgAdmin 4 is a web-based administration tool for the PostgreSQL database. It provides a browser-based graphical interface for managing PostgreSQL servers, letting you create database connections, run queries, and administer users, roles, and tables without relying on the command line. It is aimed at self-hosters and database administrators who want a centralised dashboard for one or more PostgreSQL instances. pgAdmin 4 is maintained by the official pgAdmin project and is commonly deployed as a Docker container alongside your database.

## Platform availability

Available on 3 of 9 platforms: Unraid, TrueNAS, Helm.

## Health score

81/100 (Excellent), based on 3 of 4 factors.
- Maintained: 100 (last commit 22 days ago)
- Popular: 72 (3,869 GitHub stars)
- Easy to install: 55 (3 install platforms, install notes, Docker image)

## Links

- GitHub: https://github.com/pgadmin-org/pgadmin4
- TrueNAS: https://apps.truenas.com/catalog/pgadmin
- Documentation: https://www.pgadmin.org/support/
- Docker Hub: https://hub.docker.com/r/dpage/pgadmin4/
- Kubernetes (Helm): https://artifacthub.io/packages/helm/runix/pgadmin4
- Unraid: https://ca.unraid.net/apps/pgadmin4-0pgq7100njo4ds?q=pgadmin4
- Official website: https://www.pgadmin.org/

## Common questions

### How do I set the first pgAdmin account when running the container?

Set the PGADMIN_DEFAULT_EMAIL and PGADMIN_DEFAULT_PASSWORD environment variables when starting the container.

### Which ports should be kept free for the pgAdmin and PostgreSQL Docker setup?

Keep port 5050 free for pgAdmin and port 5432 free for PostgreSQL. These are the ports used to reach pgAdmin at localhost:5050 and the database server.

### How do I connect pgAdmin to a PostgreSQL server after logging in?

Open pgAdmin at localhost:5050, log in, and add a server with the database hostname, username, and password. The example uses hostname postgres and the credentials from the database env file.

### Where should I report bugs or ask for pgAdmin support?

End-user questions go to the pgadmin-support mailing list, while bugs should be reported on the issue tracker. Security issues have a private address listed for them.

### How are pgAdmin releases supported?

pgAdmin follows a rolling release policy and only supports the latest release. Fixes and new features are released in the next version rather than backported to older versions.

## Alternatives

- Beekeeper studio: Beekeeper Studio is a cross-platform, open-source SQL editor and database manager that helps developers and database administrators connect…
- DBeaver: A versatile, open-source database tool for developers and administrators supporting multiple databases via JDBC drivers with extensive plug…
- DataGrip: DataGrip is a database IDE from JetBrains that is tailored to suit specific needs of professional SQL developers.
- DbGate: DbGate is a cross-database SQL and NoSQL client that lets you manage MySQL, PostgreSQL, Microsoft SQL Server, Oracle, MongoDB, SQLite, and…
- HeidiSQL: Supports MySQL, MariaDB, Microsoft SQL, and PostgreSQL for data viewing, editing, and exporting with no tracking and offline capabilities.
- LibreDB Studio: LibreDB Studio is an open source (MIT), self-hosted SQL IDE.
- Navicat: Navicat is a database administration tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and…
- TablePlus: A native app which helps you easily edit database data and structure.
- TablePro Database Client: TablePro is a free, open-source database client for macOS and iOS.
- Valentina Studio: FREE native AI enabled database manager for RDBMS: DuckDB, MariaDB, MySQL, Parquet, PostgreSQL, SQLite, SQL Server, Valentina DB, and Mongo…
- cloudbeaver: CloudBeaver is a self-hosted, web-based database manager that provides a rich browser interface for connecting to and managing PostgreSQL,…

---
Source: Our Local Host (https://ourlocalhost.com/app/317/pgadmin-4), the self-hosted and open-source app directory.