RSS
Логотип
Баннер в шапке 1
Баннер в шапке 2

Postgres Pro Enterprise Manager (PPEM)

Product
Developers: Postgres Professional (PPG, Postgres Professional)
Last Release Date: 2024/07/03
Technology: Office applications

Content

2024

Postgres Pro Enterprise Manager (PPEM) 1.5 with PITR recovery

Postgres Professional on July 3, 2024 introduced an updated version of Postgres Pro Enterprise Manager (PPEM) 1.5, a graphics platform for comprehensive management and monitoring of DBMSostgres Pro.

The RREM is designed as a "single window" and allows you to work with all instances databases from a single console through, browser greatly simplifying the daily work of the database administrator. data

The solution covers a full range of tasks from four main categories: maintenance and configuration, performance diagnostics, routine task control, backup and recovery. Built-in monitoring allows you to track basic performance metrics and create your own graphics that visualize the load on the customer's information system database and much more.

Postgres Pro Enterprise Manager version 1.5 introduces the following key changes:

  • Added pages to display the progress of routine tasks based on pg_stat_progress views;
  • Expanded the ability to manage job schedules;
  • Added the ability to manage the settings for storing backups at the directory and instance level;
  • Added the ability to PITR recovery;
  • Added the ability to secure backups;
  • Added page with lock tree;
  • Added configuration preset for OLTP load;
  • Added support for the latest versions of the Red OS platforms, Ubuntu.

In addition, many improvements have been made to the API and interface of the web application, a number of bugs have been fixed, and much more.

PPEM is available to users of any Postgres Pro DBMS. The platform can also be used for hybrid landscapes: Postgres Pro + DBMS with. open source PostgreSQL

Monitoring, Diagnostics, and Database Management in a Single Window

Since December 2023, all users of the Russian DBMSostgres Pro can freely work with Postgres Pro Enterprise Manager (PPEM), a graphics platform for efficient and convenient management of Postgres Pro and PostgreSQL databases. What functions for monitoring, diagnostics and management are in PPEM - in our review. Read more here.

Postgres Pro Enterprise Manager 1.4.0 with Database Object Management

Postgres Professional introduced the Postgres Pro Enterprise Manager (PPEM) update on May 13, 2024, a graphics platform for comprehensive management and monitoring of DBMSostgres Pro.

The RREM is designed as a "single window" and allows you to work with all instances databases from a single console through, browser greatly simplifying the daily work of the database administrator. data The solution covers a full range of tasks from four main categories: maintenance and configuration, performance diagnostics, routine task control, backup and recovery. Built-in monitoring allows you to track basic performance metrics and create your own graphics that visualize the load on the customer's information system database and much more.

Postgres Pro Enterprise Manager 1.4.0 introduces the following changes:

  1. Added the ability to manage database objects: schemas, tables, indexes, sequences, functions.
  2. Added physical replication cluster detection and cluster status display.
  3. The SQL Statistics page has been changed: the table structure has been redesigned, a sub-page with detailed statistics for a separate query type has been added.
  4. Added table view of the table structure: layers, TOAST, storage parameters.
  5. Continue to integrate the plan visualization library:
    1. added compatibility with plans from pg_query_state;
    2. Enables the visualization of plans from the Sessions page.
    3. The rendering is consistent with the overall interface style.
  6. Added the ability to synchronize backup information from the agent to the repository.

Also, the updated version has expanded the informativity of the task console, fixed a number of errors and much more.

PPEM is available to users of any Postgres Pro DBMS. The platform can also be used for hybrid landscapes: Postgres Pro + DBMS with. open source PostgreSQL

Postgres Pro Enterprise Manager 1.3 with diagnostic profiler support PGPRO_PWR

Postgres Professional on February 8, 2024 introduced an updated version of Postgres Pro Enterprise Manager (PPEM), a graphics platform for comprehensive management and monitoring of DBMSostgres Pro.

The REM is designed according to the principle of a "single window" and allows you to work with all instances databases from a single console through. browser The solution covers the full range of database administrator tasks, data greatly simplifying work on routine tasks.

Postgres Pro Enterprise Manager 1.3 introduces the following changes:

  • Improved expressiveness of the user interface
  • Added support for a diagnostic PGPRO_PWR profiler
  • Added information an instance role screen
  • added the ability to create groups of RREM users;
  • LDAP support is implemented;
  • Forced termination of a session or request
  • added the ability to schedule scheduled tasks.

In addition, this version has optimized the performance of the application and fixed bugs.

PPEM is available to users of any Postgres Pro DBMS. The platform can also be used for hybrid landscapes: Postgres Pro + DBMS s. open source PostgreSQL