Introduction

This repository holds the Dockerfile image used to build the PgAdmin application currently available the Edge Orchestration Marketplace. PgAdmin 4 is an open-source management tool for PostgreSQL databases. It provides a user-friendly interface to manage databases, run SQL queries, and perform various administrative tasks.

Features

• User-Friendly Interface: Easy to navigate and manage your databases.
• SQL Query Tool: Write, execute, and save SQL queries.
• Data Import/Export: Import and export data in various formats.
• Backup and Restore: Easily backup and restore your databases.
• Graphical Query Builder: Build queries visually without writing SQL.

Prerequisites

1. You must have both PostgreSQL and PgAdmin installed via the Edge Orchestration Marketplace.
2. Obtain the IP address assigned to the pgadmin and postgresql application during setup once online.
3. PostgreSQL must be setup within the same network (eth port).

Use Cases

PgAdmin is intended to be used alongside PostgreSQL as its management tool. For extensive feature documentation, visit https://www.pgadmin.org/features/.

PgAdmin Setup

1. Launch the PgAdmin Web Interface: http://{edgeapp_ip}:5050.
2. To log in use the default username/email:edge_admin@emerson.com and password:Emerson#123. This should land you on the homepage of PgAdmin.
3. To connect with your PostgreSQL database created during application deployment, click on Add New Server. Fill in a name for the server.
4. Click on the Connection tab from the server registration form. Fill in host name / address with the postgresql IP address assigned to the container when deployed. You can find this under the Network tab of the Edge App instance. Use 5432 for the port. For the maintenance database, use postgres. For the username, the default is postgres and the default password is Emerson#123.
5. When connected, you should be able to see the database.

Supported Applications in the Marketplace

PgAdmin is commonly used as a database for a number of web applications. Keep posted on this list as more marketplace apps that are supported by PgAdmin are added.