Pgadmin

Description

Split into two applications (Kubegres and PgAdmin), it provides a secure and easy-to-use PostgreSQL environment. Each PostgreSQL cluster is secured by the PostgreSQL Clustering application, which is simple and completely transparent. Kubegres is developed and maintained by the PostgreSQL community, like some other solutions. We equipped the environment with a replicated 3-node PostgreSQL cluster as an example. PgAdmin is the essential PostgreSQL administration/development tool, allowing you to view and debug SQL queries/stored procedures or other modeling done within a PostgreSQL instance.

Uses and Functionnalities

• Visual database management: Allows users to create, modify, and delete databases, tables, indexes, and other database objects.

• Query tool: Provides an SQL editor with syntax highlighting, autocomplete, and query execution features for running and debugging SQL queries.

• Data browsing and editing: Enables viewing, filtering, and editing table data directly from the interface.

• Backup and restore: Supports database backup and restore operations to safeguard data.

• User and permission management: Facilitates managing database users and roles, including granting and revoking permissions.

• Monitoring: Offers dashboards and statistics to monitor database performance and server activity.

• Support for multiple PostgreSQL versions: Compatible with various PostgreSQL releases, ensuring flexibility.

• Extensible with plugins: Supports extensions to add more features.

• Backup job scheduling: Automates routine backup tasks through job scheduling in pgAgent.

CICD integration method

To enable Pgadmin, set the following variables in your main configuration file.

pgadmin4 = {
    enabled      = true
    version      = "9.0"
    namespace    = "pgadmin4"
    component    = "dp-apps"
    release_name = "pgadmin4"
    ingress      = true
    url_prefix   = "pgadmin4"
}

API / Swagger

Releases

Official documentation

PgAdmin4 documentation