Introduction

This repository holds the Dockerfile image used to build the PostgreSQL application currently available the Edge Orchestration Marketplace. PostgreSQL is an open-source relational database management system (RDBMS). It is known for its robustness, extensibility, and standards compliance, making it a popular choice for developers and database administrators.

Features

• ACID Compliance: Ensures reliable transactions.
• Extensibility: Supports custom functions, data types, and extensions.
• Advanced Data Types: Includes support for JSON, XML, and arrays.
• Full-Text Search: Built-in full-text search capabilities.
• Concurrency Control: Efficient handling of concurrent transactions.

Prerequisites

1. You must have both PostgreSQL installed via the Edge Orchestration Marketplace. PgAdmin is optional but is strongly suggested given the lack of console access to containers in the Edge Orchestration.
2. A volume instance of at least 10GB is ideal for larger scale usage.
3. If setting up with PgAdmin, must be setup within the same network (eth port).

Use Cases

For extensive feature documentation, visit https://www.postgresql.org/docs/.

PostgreSQL Setup

Deployment Configuration

1. Deploy the application from the marketplace. It is intended to run as a background service and uses port 5432 for database connections.

2. Security Configuration: PostgreSQL credentials must be configured during deployment via environment variables:

   • POSTGRES_PASSWORD - Set a secure password for the postgres user
   • POSTGRES_USER - (Optional) Configure a custom username if needed

   Important: For production deployments, always use strong, unique passwords and change any temporary credentials immediately after first use.

Network Configuration

1. The IP address assigned to the PostgreSQL container can be found in the Network tab of the app instance in the Edge Orchestration interface.

2. Use PgAdmin or another PostgreSQL client to connect to and manage the database. The connection requires:

   • Host: <postgres_container_ip> (obtain from Network tab)
   • Port: 5432
   • Database: postgres (default maintenance database)
   • Username: As configured during deployment
   • Password: As configured during deployment

Security Best Practices

• Never use default or weak passwords in production environments
• Supply credentials via environment variables or secure configuration management
• Restrict network access to authorized clients only
• Regularly backup your databases
• Keep PostgreSQL updated to the latest stable version
• Review connection logs periodically for unauthorized access attempts

Supported Applications in the Marketplace

PostgreSQL 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 PostgreSQL are added.

1. MLFlow - EmersonDeltaV/mlflow.