PgAdmin4

pgAdmin is a powerful, open-source administration and development platform for PostgreSQL. It provides a web-based graphical interface that simplifies database management, query execution, server monitoring, and administration tasks for PostgreSQL databases.

Features of pgAdmin:

• 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.