I saw the light production of the project tempoard 8.0 , developing a Web interface for remote control, monitoring, setting up and optimizing the PostgreSQL DBMS. The product includes a lightweight agent installed on each server with PostgreSQL, and the server component that centrally controls agents and collects statistics for monitoring. The code is written in Python and is distributed under the free license postgresql license.
- The ability to control through a single centralized web interface of hundreds of copies of the DBMS PostgreSQL.
- The availability of information screens for evaluating both the general condition of all the DBMS and a more detailed assessment of each copy.
/center> /center> - monitoring the state of DBMS using various metrics.
- Support for managing the sessions performed.
- tracking of cleaning operations (Vacuum) of tables and indices.
- tracking slow requests to the database
- interface for optimizing postgresql settings.
In the new version:
- Authentication and the organization of the ligament channel between the control interface and agents. The changes led to the simplification of the deployment of agents and the increase in the security of the communication channel with them. All requests for agents are now additionally certified by digital signature using asymmetric encryption on open keys, and the interface acts as an identification provider for agents. Authentication using passwords jointly defined on the side of the agent and the interface is no longer used. By passwords, only the organization of users connection is carried out to the interface.
- A new command line interface is proposed. Separate utilities Tempoard-Migratedb and Tempoard-Agent-Segister are replaced by built-in commands called through executable Tempoard and Tempoard-Agent files. Added built -in commands to perform typical operations of administration and monitoring from the command line.
- Added Support for PostgreSQL 15, RHEL 9 and Debian 12. Contained support by PostgreSQL 9.4 and 9.5, as well as Python 2.7 and 3.5.
- The team “Register-Inchstance” for registration has been added to Tempoard
Agents, which, unlike the Tempoard-Agent Register, is performed on the server side and does not require network availability of the agent, i.e. It can be used to add new specimens in Offline-mode. - In the agent, the number of transactions used to control the postgreSQL instance is reduced by 25%. The abbreviations were achieved by caching of typical values and multiplexing tasks.
- The size of the stored monitoring data is reduced by default to 2 years.
- Added the ability to download inventory data in CSV format.
- Automatic restart of the background processes of the interface and agent after emergency completion.
/Media reports.