Ecosystem:PostgreSQL only:Database administration/development

From PostgreSQL wiki
Jump to: navigation, search

EDB Postgres Enterprise Manager

  • Provider -- EnterpriseDB Corporation
  • Website -- https://www.enterprisedb.com/products/edb-postgres-platform/edb-postgres-enterprise-managerpem
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 9.1 or higher
  • Verified PostgreSQL versions -- See: https://www.enterprisedb.com/services/edb-supported-products-and-platforms#PEM
  • Last update (YYYY-MM-DD) -- 2017-6-7
  • Description -- EDB Postgres Enterprise Manager is designed for monitoring, managing and tuning large scale installations of local and remote Postgres deployments. DBA features include: customizable monitoring dashboards with drill down tables/charts, over 225 pre-defined monitoring probes, custom probes, server auto-discovery, At-A-Glance global status and performance dashboards, Capacity Manager, Audit Manager, Log Manager, Log Analyzer Expert, Postgres Expert (best practice configuration engine), SQL Profiler, Index Advisor, Tuning Wizard, Team Management, flexible SMTP/SNMP alerts, and job scheduler. Developer features include: visual SQL debugger to step through server side stored procedures and triggers, drag and drop SQL query editor, data grids for instant editing, Graphical Query Editor, syntax highlighting, indentation, auto completion, macros and a graphical explain plan.
  • Additional info -- click here

repmgr

  • Provider -- 2ndQuadrant
  • Website -- https://www.2ndquadrant.com/
  • License -- GPL v3
  • Interoperability level -- explicitly supports PostgreSQL 9.3 or higher
  • Verified PostgreSQL versions -- https://www.2ndquadrant.com/en/resources/repmgr/
  • Last update (YYYY-MM-DD) -- 2020-04-13
  • Description -- repmgr is a popular tool for PostgreSQL replication and failover management. It simplifies administration and daily management, enhances productivity, and complements the built-in replication capabilities in PostgreSQL.
  • Additional info -- click here

pgMustard

  • Provider -- pgMustard
  • Website -- https://www.pgmustard.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 9.6 or higher
  • Verified PostgreSQL versions -- https://www.pgmustard.com/walkthrough/
  • Last update (YYYY-MM-DD) -- 2020-08-17
  • Description -- pgMustard visualises EXPLAIN output, and gives tips to improve performance.
Retrieved from "https://wiki.postgresql.org/index.php?title=Ecosystem:PostgreSQL_only:Database_administration/development&oldid=35357"