A new version of Postgres Pro Enterprise Manager 2.0 (PPEM 2.0), a comprehensive solution for administering and monitoring the Postgres Pro database infrastructure, has been released. This major update marks an important step in the evolution of PPEM, offering significant improvements in performance, scalability, and usability.
PPEM 2.0 is designed to provide DBAs and system administrators with a powerful tool to effectively manage and monitor PostgreSQL database environments of any size. The new version focuses on solving key problems faced by specialists responsible for the stability and performance of mission-critical databases.
Key innovations of PPEM 2.0:
- Transition to Go backend . The PPEM 2.0 architecture has been completely redesigned using a high-performance backend written in Go. This provides a significant increase in speed and reduced resource consumption for both the PPEM manager itself and its agents. Now PPEM 2.0 is able to efficiently serve a significantly larger number of DBMS instances while maintaining a low load on hardware resources. This is especially important in the context of constantly growing infrastructures and high scaling requirements.
- Automatic resource discovery . PPEM 2.0 introduces automatic discovery of DBMS instances. The PPEM agent can now automatically find and register PostgreSQL instances on your network. This greatly simplifies the process of deploying PPEM in large environments and minimizes manual operations for adding and configuring agents and instances. PPEM 2.0 takes care of the routine, allowing you to focus on more important tasks.
- Integration with Postgres Pro OpenTelemetry Collector . PPEM 2.0 is tightly integrated with Postgres Pro OpenTelemetry Collector (pgpro-otel-collector), a modern telemetry collection tool. Now PPEM 2.0 can use the metrics and logs collected by the collector to comprehensively monitor the health of your databases. The integration is implemented in two ways, providing maximum flexibility:
- Internal Storage: PPEM 2.0 can receive and store telemetry data from Collector in an embedded database.
- External storage systems: PPEM 2.0 supports integration with external metrics and log storage systems such as Prometheus, VictoriaMetrics, and ElasticSearch. The main advantage of using external storage is the ability to flexibly scale and independently administer. This ensures high system performance and reliability, allowing PPEM 2.0 to be embedded into an existing monitoring infrastructure using familiar tools and solutions.
- REST API redesign and focus on automation . PPEM 2.0 has a completely redesigned application programming interface (API). The new API is implemented in the REST architecture, which makes it intuitive and convenient for integration with automation systems and scripts. This is the first step towards publishing the API and opens up new opportunities for automating Postgres Pro management and monitoring tasks, allowing you to integrate PPEM 2.0 into your DevOps processes.
Pre-release documentation is available inside the PPEM backend installation packages (/usr/share/doc/ppem).