# pgadmin

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

Canonical page: https://ourlocalhost.com/app/7251/pgadmin

## Description

pgAdmin is a web based administration tool for the PostgreSQL database.

## Platform availability

Available on 2 of 9 platforms: TrueNAS, Helm.

## Links

- TrueNAS: https://apps.truenas.com/catalog/pgadmin/
- Kubernetes (Helm): https://artifacthub.io/packages/helm/cetic/pgadmin
- Official website: https://www.pgadmin.org/

## Common questions

### How do I start pgAdmin in Docker?

Pull and run the dpage/pgadmin4 image, map host port 80 to container port 80, and set PGADMIN_DEFAULT_EMAIL and PGADMIN_DEFAULT_PASSWORD.

### Which Linux package should I install if I only want the web UI?

Use pgadmin4-web for web only; pgadmin4 installs both desktop and web, while pgadmin4-desktop is desktop only.

### Why can't pgAdmin connect to my PostgreSQL server?

The server connection username in pgAdmin may need to match the PostgreSQL superuser created during setup, since the default username can differ.

### Is there paid support for pgAdmin?

No, pgAdmin does not offer paid support. You can use the active mailing list or public issue tracker, and the development team reads both.

## 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.
- 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/7251/pgadmin), the self-hosted and open-source app directory.