Ecosystem:PostgreSQL only:Database administration/development

From PostgreSQL wiki
Jump to navigationJump to search

dbForge Studio for PostgreSQL

  • Provider -- Devart
  • Website -- https://www.devart.com/dbforge/postgresql/studio/
  • License -- proprietary
  • Interoperability level -- supports PostgreSQL 8.4 or higher
  • Verified PostgreSQL versions -- https://docs.devart.com/studio-for-postgresql/getting-started/requirements.html
  • Last update (YYYY-MM-DD) -- 2023-05-24
  • Description -- dbForge Studio for PostgreSQL is a feature-rich IDE designed for database development and management. The tasks that can be handled with its help include completion-aided SQL coding, comparison and synchronization of databases, data management, data analysis and reporting, query optimization, and customizable generation of realistic test data.

Key features:

1. SQL Development

  • SQL editor
  • Code autocompletion
  • Code formatting
  • Code snippets
  • Syntax check

2. Database Explorer

  • Easy navigation
  • Quick data import and export
  • Quick object information
  • Generate Script As

3. Data Editor

  • Data viewing, sorting, grouping, and filtering
  • Paginal mode
  • Auto-search mode
  • Cached Updates mode
  • Card View mode

4. Data & Schema Compare

  • Comparison of database schemas
  • Comparison of table data
  • Database synchronization

5. Data Export and Data Import

  • Support for 10+ most widely used file formats
  • Intuitive wizards
  • Customizable options
  • Templates for recurring operations

6. Query Profiler

  • Plan Tree
  • Query execution diagram
  • List of top operations on the server
  • Query execution plan in XML

7. Data Generator

  • Generation of realistic test data

8. Data Analysis & Reporting Tools

  • Data Report Wizard
  • Report Designer
  • Pivot Tables
  • Chart Designer
  • Data Editor
  • Master-Detail Browser

9. Supported Operating Systems

  • Windows
  • Linux (via CodeWeavers CrossOver)
  • MacOS (via CodeWeavers CrossOver)

For additional information, visit the product page.

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/docs/
  • Last update (YYYY-MM-DD) -- 2021-02-22
  • Description -- pgMustard is a quick way to review EXPLAIN ANALYZE output, and it also provides tips to improve performance.