← Directory

PgAdmin

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

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

Platform availability

Available on 2 of 9 platforms

  • Unraid (not listed)
  • TrueNAS
  • Umbrel (not listed)
  • ZimaOS (not listed)
  • Proxmox (not listed)
  • Helm
  • Mac (not listed)
  • Windows (not listed)
  • Linux (not listed)

Health score?A 0-100 score computed nightly from four factors: maintained (40%: recent commits and steady activity), popular (25%: GitHub stars, log scale), easy to install (20%: platforms, install notes, setup guides, Docker image) and light to run (15%: minimum RAM, ARM support). When the source code has been checked, a fifth factor, security check (20%: automated scan for committed secrets, unsafe desktop-app settings, known-vulnerable dependencies and project hygiene; any serious finding caps it at 20), is added. Factors without data are left out and the rest are rescaled.

76/100 Good

Maintained
100last commit 3 days ago
Popular
723,909 GitHub stars
Easy to install
352 install platforms, install notes
Light to run
No data

Based on 3 of 4 factors.

Availability: platform listings confirmed today

No GitHub repository data collected yet.

Resources & Compatibility

Requirements not published yet.

First-install notes

  • Fill in the credential files before setup Before starting the containers, create pg-env.list and pgadmin-env.list with the PostgreSQL user/password and your pgAdmin login email/password, because the containers use them to set up the database and your first pgAdmin account. source
  • Keep data safe with the named volumes Use the setup script’s pgvolume and pga4volume Docker volumes so PostgreSQL data and pgAdmin settings survive container restarts or recreation; without them, your database and saved logins disappear when containers are removed. source
  • Open pgAdmin, log in, then add the server Open http://localhost:5050 in your browser and log in with the email/password from pgadmin-env.list, then add a server using hostname postgres and the database user/password. pgAdmin starts empty, so without adding this server you cannot manage the PostgreSQL database from the web interface. source

Fetched today - each note links to its source

Alternatives (10)

  • 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,…

Checked today - source: AlternativeTo

Common questions

Can pgAdmin be self-hosted in a container?

Yes, pgAdmin can run in desktop or server mode and in containers.

What authentication-related setting does the pgAdmin FAQ cover?

It covers the Master Password, including how to use it or remove it.

Can pgAdmin connect to PostgreSQL from a Windows installation?

Yes; one user reported no problems connecting pgAdmin when it was downloaded for Windows.

Why might pgAdmin 4 be slower than pgAdmin 3?

pgAdmin 4 is written in Python, while the older pgAdmin 3 was written in C++. Python is described as slower than languages such as C++ or Java.

Answers sourced from stackoverflow.com, www.pgadmin.org, www.pgadmin.org, www.reddit.com

Community

Collected today - public community threads