PgAdmin4

• Provides an intuitive web interface for creating, managing, and monitoring PostgreSQL databases, schemas, tables, indexes, views, and other database objects.
• Includes a powerful Query Tool with syntax highlighting, query history, execution plans, and data editing capabilities for efficient SQL development.
• Supports user and role management, backup and restore operations, database import/export, and server monitoring through an easy-to-use graphical interface.
• Offers advanced administration features such as maintenance tasks, performance dashboards, object dependency tracking, and extension management.
• Enables secure remote access with role-based authentication, SSL support, and centralized management of multiple PostgreSQL servers.

Usage instructions:

sudo su

Access the web interface:

http://SERVER_IP:5050

To check database credentials: cat /var/pgadmin/credentials.txt

To check the running container:

docker ps

To view container logs:

docker logs pgadmin4

Disclaimer: pgAdmin is an open-source administration and development platform for PostgreSQL distributed under the PostgreSQL License. It is not affiliated with, endorsed by, or sponsored by PostgreSQL Global Development Group or any other organization. pgAdmin is provided "as is" without warranties of any kind, either express or implied. Users are responsible for securing their deployments, managing access credentials, and complying with applicable licensing terms and organizational security policies.