This release requires a database schema migration. Use temboard-migratedb script to proceed.
- Unified authentification: agents now accepts UI as source of identity.
- New database migration engine.
- Removed parameter of
temboard --debug
CLI option. - Improved error logging.
- Move
temboard-migratedb
astemboard migratedb
subcommand. - Move
temboard-agent-register
astemboard-agent register
subcommand. - New command
temboard generate-key
for generating signing key. - New command
temboard-agent fetch-key
to accept UI signing key. - New subcommands
temboard query-agent
,temboard routes
,temboard runtask
,temboard schedule
,temboard web
,temboard-agent routes
,temboard-agent runtask
andtemboard-agent web
for debugging. - New agent option:
[temboard] ui_url
, pointing to UI URL. - New agent auto_configure.sh required parameter: UI URL.
- temBoard agent auto_configure.sh does not configure file logging anymore. temBoard UI & agent package does not ship logrotate file anymore. temBoard UI & agent can still log to file if you configure it to do so.
- temBoard agent packages does not ship mono-installation service file. Use
auto_configure.sh
andtemboard-agent@.service
instead. - temBoard agent RPM packages does not ship
temboard-agent.conf
anymore. Useauto_configure.sh
instead. - temBoard agent deb does not ship
temboard-agent.init
anymore. Use systemd instead. - Post install script of temBoard UI RPM does not execute auto_configure.sh.
- temBoard UI RPM does not create
temboard
UNIX user. Use auto_configure.sh instead. - Fast collect of monitoring and statements metrics upon agent registration.
- temBoard UI dropped push-metrics handler from pre-6.0 push metric collect.
- Removed scripts
temboard-agent-adduser
andtemboard-agent-password
. - Agent dropped users file and configuration.
- Python 2.7 and 3.5 support is deprecated and will be removed in next major release.
- Debian Stretch support is deprecated and will be removed in next major release.
- temBoard agent now depends on cryptography and bottle.
- temBoard agent pools connections to PostgreSQL used by web API, reducing connections stress on PostgreSQL.
- Download instance inventory as CSV.
- Format PostgreSQL start time in dashboard.
- Avoid modal for dashboard refresh error.
- temBoard agent auto_configure.sh conditionnaly enable statements plugins.
- temBoard agent auto_configure.sh now generates a single configuration file.
- Dropped temBoard agent HTTP endpoint /monitoring/probe/*.
- temBoard server waits for locks in monitoring collect. Abort long collect
task. New parameter
[monitoring] collect_max_duration
.
- Fix heap bloat probe.
- Fix statements not purged.
- Collect metrics by agent batch. Huge performance boost.
- Log HTTP request response time.
- Check agent key on registration.
- docker: New tag
7
for stable branch. - docker: Reduce image size using multi-stage build.
Agent:
- docker: Fix build.
- docker: Properly stop container on failure.
- Fix performances issues with monitoring.
- Show runtime libpq version in logs and --version.
- Authenticate with agent using both header and query arg. 8.0 will remove query arg auth.
- Packages for bullseye for both UI and agent.
- Drop jessie package.
- Always set application_name.
Server:
- Fix database ownership on creation.
- Fix first collector run failure on new agent.
- Fix tracebacks when an agent is down.
- Fix 'null' instance comment with auto register.
- Ship a /usr/share/temboard/sql/reassign.sql script to fix ownership.
- Define a shell to temboard UNIX user.
- Review defaults temBoard user groups.
- Optionnal performance tracing in temBoard UI logs.
- Moving to Python3 on stretch, buster and bullseye.
- Drop another tooltip breaking dropdown menu.
- Monitoring: Time SQL queries for archive and aggregation.
systemctl reload temboard
now reload temBoard configuration.
Agent:
- Fix database probes always executed on same database.
- Reduce reconnexion in monitoring probes.
- Explicitily requires psycopg2 2.7+ on debian.
- Ignore loopback and tmpfs file systems.
- Drop Python2 support
- Build RHEL8 package with RockyLinux 8.
- Support PostgreSQL 14.
- Fix deadlock in monitoring.
- Fix UI glitches.
- Restructured documentation.
- Improved logging messages.
- Dropped Debian Jessie support.
- agent: Monitor only local filesystem size.
- agent: Set umask 027 in auto_configure.sh.
- agent: Details components version in
temboard-agent --version
output. - agent: Fix sysv init script shipped on systemd by debian package.
- Fix wrong column name in SQL for chartdata for rollback transactions (monitoring) @pgiraud
- Return valid JSON if no result is returned by postgres (monitoring) @pgiraud
- Commit after alert processing @bersace
- Fixed bug in wheel generation @pgiraud.
- Improved performance of the home page (instances list), by @pgiraud.
- Activity filters are kept, by @pgiraud.
- Better support for history navigation in monitoring, by @pgiraud.
- Don't highlight short idle_in_transaction queries, by @pgiraud.
- Added comment field for instance settings, by @pgiraud.
- Allow users to choose the refresh interval (whenever a date range picker is used), by @pgiraud.
- Agent: support for RHEL/CentOS 6 has been dropped.
- Agent: support for RHEL/CentOS 8 has been added.
- Agent scripts now use the Python interpreter of their installation, not the first found in env, by @bersace.
- Alembic version table is now hosted in
application
schema, by @bersace.
- Always using TLS even if set to False, by @bersace.
- SMTP port misinterpreted, by @bersace.
- Authenticate with empty login or password, by @bersace.
- Double error with unserializable error in worker, by @bersace.
- Test PG access by temboard role after repo creation, by @l00ptr
Fixed compatibility with old Alembic 0.8.3 shipped on RHEL7, by @bersace.
This release requires a special step before restarting temBoard. Please read upgrade to 6.0 documentation.
- Full PostgreSQL 12 support, including monitoring and configuration, by @pgiraud.
- Search config
temboard.conf
default config file in working directory by @bersace. - temBoard repository schema is now versionned, by @bersace.
- Load external plugins from setuptools entrypoint
temboard.plugins
, by @orgrim. - Debian Buster testing & packaging, by @bersace.
- Agent:
purge.sh
script to clean an agent installation, by @bersace.
- Double loading of legacy plugins, by @bersace.
- Impossibility to delete instance with SQLAlchemy < 1, by @pgiraud.
- Impossibility to schedule ANALYZE, VACCUM or REINDEX, by @bersace.
- Fix list of scheduled tasks in maintenance plugin, by @pgiraud.
- Default configuration file is not required, by @bersace.
- Log error message when alert processing fails, by @bersace.
- Agent:
auto_configure.sh
refuses to overwrite existing configuration, by @bersace.
- Purge policy for monitoring data by @julmon
- Pull mode: temboard server can now pull monitoring data from the agents by @julmon
- Agent does not support push mode anymore @julmon
- Performances improvements of asynchronous task management by @julmon
- Support for reindex on table and database by @pgiraud
- Support for analyze/vacuum for database by @pgiraud
- Send notifications by SMS or email on state changes by @pgiraud
- Allow to use either psycopg2 or psycopg2-binary by @bersace
- Monitoring shareable urls by @pgiraud
- Use
pg_version_summary
when possible by @pgiraud - Database schema, please see the upgrade documentation
- Removed user notifications from dashboard by @pgiraud
- Prevent endless chart height increase on Chrome 75 by @pgiraud
- Restrict access to instance to authorized users by @julmon
- Remove monitoring data when removing an instance by @pgiraud
- Move
metric_cpu_record.time
toBIGINT
by @julmon
- Full screen mode for home page by @pgiraud
- Full screen mode for dashboard by @pgiraud
- Limit double authentication to not read only APIs by @pgiraud
- Maintenance plugin by @pgiraud
- Collapsible sidebar by @pgiraud
- New monitoring probes: replication lag and connection, temporary files by @julmon
- UI functional tests by @bersace
- Support Tornado 4.4 and 5 by @bersace
- Add auto configuration script by @bersace
- Show number of waiting/blocking req in activity tabs by @pgiraud
- Show availability status on home page by @pgiraud
- Dashboard like home page by @pgiraud
- Improve activity views by @pgiraud
- Review web framework by @bersace
- Review debian packaging by @bersace
pg_hba.conf
andpg_ident.conf
edition removed frompgconf
plugin by @pgiraud