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.1 or higher
  • Verified PostgreSQL versions -- https://www.2ndquadrant.com/en/resources/repmgr/
  • Last update (YYYY-MM-DD) -- 2018-03-09
  • Description -- repmgr helps DBAs and System Administrators manage a cluster of PostgreSQL databases. It simplifies administration and daily management, enhances productivity and reduces the overall costs of a PostgreSQL cluster.
  • Additional info -- click here
Personal tools