# 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

79/100 (Good), based on 3 of 4 factors.
- Maintained: 100 (last commit 12 days ago)
- Popular: 72 (3,869 GitHub stars)
- Easy to install: 45 (2 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: Open Source SQL Editor and Database Manager for MySQL, SQL Server, Postgres, Redshift, Sqlite and more.
- 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 The Smartest SQL+noSQL Database Client Cross-database MySQL, PostgreSQL, MS SQL, Oracle, MongoDB, SQLite and others
- 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.