Ecosystem:PostgreSQL only:Database administration/development

From PostgreSQL wiki
Jump to: navigation, search

dbForge Studio for PostgreSQL

  • Provider -- Devart
  • Website -- https://www.devart.com/dbforge/postgresql/studio/
  • License -- proprietary
  • Interoperability level -- supports PostgreSQL 8.1 or higher
  • Verified PostgreSQL versions -- https://docs.devart.com/studio-for-postgresql/getting-started/compatibility.html
  • Last update (YYYY-MM-DD) -- 2021-07-29
  • Description -- dbForge Studio for PostgreSQL is a universal GUI tool for PostgreSQL database development, management, and editing process enjoyable and easy by Devart. The PostgreSQL IDE allows users to create, develop, and execute queries, edit and adjust the code to the requirements in a convenient and UI. The tool provides the PostgreSQL data editor functionality for queries customization and property window for viewing all the required information of PostgreSQL database objects.

Key features:

1) Query Profiler

  • Plan Tree of query execution
  • Diagram of query execution with the cost of all operations as a percentage of the total batch cost
  • List of top operations taking place on the server
  • Execution plan in the XML format

2) SQL Development

  • PostgreSQL code completion
  • SQL code formatting
  • SQL syntax check
  • PostgreSQL query validator

3) Data Export and Data Import

  • 10+ file format support, including Google Sheets
  • Flexible data import and export customization
  • Handy wizards for data export and import
  • PostgreSQL data migration

4) Data Reports and Analysis

  • Data Report Wizard
  • Report Designer
  • Pivot Tables
  • Chart Designer

5) Object Explorer

  • Retrieve data from the database on a single SQL document
  • Truncate a table
  • Select Properties to view information on the object
  • Generate Script AS

6) Data Editor

  • In-place data editing
  • Look-up data editing
  • Cached Updates Mode data editing
  • Table, Text, Card Views

7) Master-Detail Browser

  • Design View for setting up relations between tables
  • Data View for handy display of results
  • Smart sorting and filtering


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.