QHB Version 1.5.3 Release Notes

Added

  • Security Profiles: Add security profile SQL commands ALTER PROFILE, CREATE PROFILE, DROP PROFILE.
  • Information Security Roles: Add SQL commands for roles IS Administrators CREATE QHBSECUREROLE, DROP QHBSECUREROLE.
  • Cluster Computing Management Module QLUSTER.
  • Application for monitoring and managing QHB instances QMAN.
  • Qbackup: Add backup holding policy and archive transaction log deleting policy.
  • PL/pgSQL: Add extension Autonomous transactions.
  • Shared Plan Cache
  • The stat_dump extension.
  • Add system administration functions set_runtime_guc and reset_runtime_guc to change the backend process configuration parameters by its PID.
  • Managing shared resources between server processes.
  • Add qhb_grant_info, qhb_stat_vacuum_tables, and qhb_stat_vacuum_database views.
  • User guide for cold re-encryption of QHB database objects.
  • Installing the QSS Encryption Module Using the Sobol PRNG HSS.
  • query_profiling: Add function qhb_wait_qep to get information about query execution.
  • Add description of working with the PL/pgSQL debugger.
  • Support for Debian 12 distribution.
  • Support for Fedora 40, 41 and 42 distributions.
  • Support for Ubuntu 24.04 distribution.
  • Support for ROSA CHROME SERVER 12.6 distribution.
  • Support for РЕД ОС 8 distribution.
  • Support for Astra Linux 1.8 distribution.

Improved

  • QHB core has been updated to be based on PostgreSQL 16.9.

Main changes:

  • Allow parallelization of FULL and internal right OUTER hash joins;
  • Allow logical replication from standby servers;
  • Allow logical replication subscribers to apply large transactions in parallel;
  • Allow monitoring of I/O statistics using the new pg_stat_io view;
  • Add SQL/JSON constructors and identity functions;
  • Improve performance of vacuum freezing;
  • Add support for regular expression matching of user and database names in qhb_hba.conf, and user names in qhb_ident.conf.
  • Update metrics collected when working with encrypted tables.

See Chapter PostgreSQL Release Notes for details.

  • qhb_audit:
    • Add the ability to enable and disable security events;
    • Add audit events "role lockout/unlock";
    • Add audit events "role profile lockout/unlock";
    • Add audit events for facts of reading, modifying and deleting data;
    • Add audit events working with stored and aggregate functions;
    • Add audit events index manipulation;
    • Add audit events configuring RLS policies;
    • Add user session audit events.
  • Metric Server: Expand metric configuration for QHB.
  • backtrace: Add the ability to limit the storage time and number of trace files.
  • qhb_dump: Add the --blobs-meta parameter.
  • qhb_queue: Expand the list of supported data types.

Corrected

  • QSS: Fix a bug in encryption.
  • Fix identified errors in the metric operation and table encryption.
  • QCP: Add description of limitations on QCP usage.

Other

  • The UREF data type has been moved from extensions to the QHB core.

  • Dangerous conditions and vulnerabilities have been corrected, eliminated or analyzed for absence:

    • CVE-2025-8715 (BDU:2025-09830);
    • CVE-2025-8714 (BDU:2025-09829);
    • CVE-2025-8713 (BDU:2025-09827);
    • CVE-2025-1094 (BDU:2025-01601);
    • CVE-2025-4207 (BDU:2025-05405);
    • CVE-2024-7348 (BDU:2024-06153);
    • CVE-2024-10979 (BDU:2024-09679);
    • CVE-2024-10978 (BDU:2024-09681);
    • CVE-2024-10977 (BDU:2024-09682);
    • CVE-2024-10976 (BDU:2024-09684).

QHB Version 1.5.2 Release Notes

Added

  • QSched: Automatic vacuum of the start log by parameters.
  • Qbim: Methods for describing objects, extension installation parameters.
  • QCP: The ability to apply parameters without restarting QCP has been added.
  • Metric Server: The group queryid for monitoring the operation of individual SQL operators has been added.
  • Metric Server: The metric group mem_stat has been added.
  • Metric Server: The SQL function metrics_config_show() has been added.
  • Security Profiles: The ability to group configure DBMS security policies for users has been added.
  • Integrity Check: The ability to control the integrity of binary files qhb-core and contrib, as well as procedures (program code) has been added.
  • Information Security Roles: New entities have been added: the roles of DBMS Administrator and DB Administrators.
  • Support for Fedora 36, ​​37, 38 and 39 distributions.
  • Support for MosOS 15.5 distribution.

Improved

  • The QHB core has been updated and is now based on PostgreSQL 15.5.
  • Metric Server: The list of metrics for the db_stat group has been expanded.
  • backtrace The fatal error filter has been improved. For the following types of errors, the generation of backtrace files has been excluded:
    • incorrect password entry;
    • absence of user;
    • absence of database.
  • Built-in Message Queue: Record type has been added.
  • QCP: A description of the connection to the DBMS has been added.
  • Qbayes: The expansion has been put into industrial operation.
  • qhb_audit:
    • the set of audit event attributes has been reworked;
    • information security events have been added:
      • creation of user accounts for the database management system;
      • modification of the attributes of database management system user accounts;
      • starting and stopping the database management system with an indication of the reason for stopping;
      • changing the database management system configuration;
      • database recovery;
      • changing the rules for access control in the database management system;
      • facts of violation of the control objects integrity;
      • creation and modification of procedures (program code) stored in databases, and views;
    • a system for rotating the audit event text log has been implemented.
  • The QHB version advanced masking option has been added.

Corrected

Other

  • Restrictions on DBMS performance in the absence of a license have been added.
  • Dangerous conditions and vulnerabilities have been corrected, eliminated or analyzed for absence:
    • BDU:2024-03569;
    • BDU:2024-01121;
    • BDU:2023-07905;
    • BDU:2023-07904;
    • BDU:2023-07840;
    • BDU:2023-04944;
    • BDU:2023-04768;
    • BDU:2023-04767;
    • BDU:2023-03247;
    • BDU:2023-03024;
    • BDU:2023-02003;
    • CVE-2024-4317;
    • CVE-2024-0985;
    • CVE-2023-2455;
    • CVE-2023-2454;
    • CVE-2022-41862;
    • CVE-2023-39418;
    • CVE-2023-39417;
    • CVE-2023-5868;
    • CVE-2023-5869;
    • CVE-2023-5870;
    • CVE-2021-45707.
  • Support for Fedora 33, 34, and 35 distributions has been discontinued.
  • Support for Astra Linux SE 1.6 distribution has been discontinued.
  • Support for Debian 9 distribution has been discontinued.

QHB Version 1.5.1 Release Notes

Added

  • Security event logging module qhb_audit.
  • Advanced functions for working with XML.
  • A flag for initializing encrypted tables has been added to the pgbench utility.
  • Metric Server: Prometheus support.
  • Metric Server: Vector support.
  • Support for Debian 10 distribution.
  • Support for RedOS 7 distribution.
  • Support for Astra Linux SE 1.7 distribution.
  • Support for Ubuntu 18.04, 22.04 distribution.
  • Support for openSUSE Leap 15.4 distribution.
  • QDLM: Module for loading metric data into the database.
  • Qbackup: Remote recovery.
  • Qbackup: Cumulative backup.
  • Qbackup: Compressed incremental backup.
  • Qbackup: Compressed remote incremental backup.
  • Qbackup: Backup from slave node.
  • External extension support:
    • mysql_fdw (MySQL foreign data wrapper for QHB);
    • Orafce (Compatibility functions and Oracle Packages);
    • pg_hint_plan (Module for configuring execution plans using "hints");
    • pg_repack (Minimal lock table reorganization module);
    • pg_store_plans (Module for tracking statistics of execution plan of SQL statements);
    • pgtt (Global temporary tables management module);
    • plpgsql_check (plpgsql extended validation module);
    • sr_plan (Query plan storage management module in QHB).

Improved

  • Some sorting optimizations have been transferred from PostgreSQL 15.
  • Some optimizations for working with files have been transferred from PostgreSQL 15.
  • QDL: Multiple improvements, significant rework.
  • Metric Server: Optimization, significant reduction in resource consumption (CPU).
  • Metric Server: Ability to restart the metric server without restarting QHB.
  • Metric Server: The group "Built-in metrics" has been added.
  • Metric Server: A lock manager metric group (lmgr) has been added to QHB metrics.
  • The ability to use hard links when upgrading QHB via qhb_upgrade has been added.
  • a configuration option for enabling/disabling trace files has been added.
  • a configuration parameter for starting the scheduler when the DBMS starts has been added.
  • a configuration parameter for starting the message queue broker at DBMS start has been added.

Corrected

  • QDL: Calculating checksums in QDL.
  • Qbackup: Multiple fixes in backup.
  • Qbackup: Stabilizing CDC operations.

Other

  • Dangerous conditions and vulnerabilities have been corrected, eliminated or analyzed for absence:
    • BDU:2019-01231,
    • BDU:2019-04174,
    • BDU:2021-05535,
    • BDU:2021-05857,
    • BDU:2021-05996,
    • BDU:2022-00821,
    • BDU:2022-02629,
    • BDU:2022-02928,
    • BDU:2022-03872,
    • BDU:2022-04971,
    • BDU:2022-05174,
    • BDU:2022-07190,
    • CVE-2021-23214,
    • CVE-2021-23222,
    • CVE-2021-43767,
    • CVE-2022-1552,
    • CVE-2022-25852,
    • CVE-2022-2625.

QHB Version 1.5.0 Release Notes

Added

  • The QHB extension Part_Import, partial import of data files from an "external" database.
  • Session level variables — qhb_variables.
  • Qbackup: Ability to validate backups (validate command).
  • Qbackup: Ability to delete WAL files when deleting a backup.
  • Support for tracking query execution status using qhb_running_queries() and qhb_dump_qep(<query_id>).
  • Experimental support for the task scheduler QSched.
  • Support for Fedora 35 distribution.
  • Support for Альт 8 СП distribution.
  • QDL: New data types.
  • QDL: API for loading data without using CSV.

Improved

  • The QHB core has been updated to be based on PostgreSQL 14.
  • Qbackup: Backup compression performance.
  • Qbayes: parameters have been added to limit the "commutative explosion".
  • Qbayes: discrete_integer (enumerated data type) has been added to the model description.
  • A vulnerability in the WAL reset process has been fixed — adjusted by the wal_after_error_sleep_delay parameter.
  • QDL: The 8Kb data size limit has been removed.

Corrected

  • Mock files for describing extensions for 2B have been added to correct scenarios of the 1C:Enterprise platform.

Deleted

  • The user interactive command string utility qsql has been removed. It is recommended to use the utility psql.

QHB Version 1.4.0 Release Notes

Added

  • Support for Fedora 34 distribution.
  • QHB extension Qbayes, statistical analysis methods based on Bayesian conditional probabilities.
  • The QHB Disk Cache Dump module provides a mechanism for saving and restoring the contents of the disk cache.
  • Qbackup: Support for remote backup using the replication protocol.
  • Qbackup: The replica subcommand to create a replica of a server.
  • Qbackup: Options for working with passwords (dialogue mode).
  • Qbackup: The directory structure has been updated
  • Qbackup: Tablespace support.
  • Qbackup: Support for CDC (Change Data Capture) for incremental backups.
  • Qbackup: Ability to quickly perform a checkpoint before a backup.
  • Qbackup: An option that allows you to base new incremental backups on the last successfully completed backups.
  • Qbackup: Ability to specify a comment for a backup when it is created.
  • Qbackup: The capabilities of the remove command have been expanded.
  • QDL: CDC compatibility mechanism.
  • QDL: Support for receiving data from stdin.
  • QCP: Support for a list of stand_by servers for automatic switching to a standby server in case of loss of connection with the current DB server.

Improved

  • Qbackup: Recovery speed for incremental backups has been increased by 2 times.
  • QDL: Multithreaded performance has been significantly improved.
  • QDL: CSV parsing error messages have been improved.
  • QSS: Increased security. Functioning in a separate process.
  • QSS: Unification of user administration and key management.

Corrected

  • Qbackup: Display of information in some errors has been corrected.
  • Qbackup: Ability to delete backup information without a directory catalog.
  • QDL: The encoding field has been removed from the configuration file (it was marked as deprecated in release 1.2.0).

QHB Version 1.3.1 Release Notes

Added

  • Support for ROSA Enterprise Linux Server (RELS) 7.

Corrected

  • Qbim extension errors that occurred in some situations when changing object versions have been fixed.
  • qhb_upgrade: The erroneous check for the number of users in the cluster being updated has been removed.
  • QCP: Display of the application_name parameter of incoming clients in Debug mode has been added.
  • Fixes to improve 2B stability.
  • Other minor fixes.

QHB Version 1.3.0 Release Notes

Added

  • Support for tables with HOLDMEM = ONLY parameter.
  • Multiple new metrics in metricsd.
  • The utility magma_key_gen for generating user keys QSS on crypto- tokens that support hardware encryption according to ГОСТ 34.12-2018 and ГОСТ 34.13-2018.
  • QDL: Support for UUID type.
  • QDL: Broad support for special values ​​for date and timestamp types: Epoch, Infinity, -Infinity.
  • Qbackup: Mechanisms for supporting and updating previous versions of the catalog.
  • Qbackup: Information about the database and catalog version has been added to the version catalog.
  • QCP: Canceling of the current query on the server when the client disconnects.
  • QCP: “Forwarding” a query to cancel the current query from the client to the end server
  • QCP: Automatic canceling of all current queries when QCP is stopped.
  • QCP: Sending heartbeat messages to inactive database connections.
  • QCP: Clients can connect to QCP via Unix domain sockets.

Improved

  • Memory handling in Tarq has been optimized.
  • Localization in qhb_upgrade.
  • MChar in 2B learned to work with like escape.
  • QDL: The recording format for the float, double precision, numeric types has been fixed.
  • QDL: The performance of the NULL value generator has been increased.
  • QDL: The performance of the analyzer of the floating point and numeric values has been increased.
  • QDL: The size of the executable file has been reduced by removing legacy code.
  • QDL: The script generator for create_table has been simplified, the likelihood of runtime errors has been reduced.
  • QCP: More flexible logging setup.
  • QCP: More detailed messages about errors that occur during operation.

Corrected

  • Vacuum leaks when using Tarq.
  • rbytea setting options.
  • Error of the invalid auth parameter in qhb_bootstrap called scram_sha_256.
  • In 2B the recursion from MChar like has been removed.
  • shared_buffers_partitions: correct parameter processing.
  • Running qhb_upgrade as root user (disabled).
  • Error during cluster initialization using qhb_bootstrap when specifying flag --waldir.
  • Qbackup: Duplicate copy ID error during fast sequential creation of several backups.
  • Qbackup: Error of the mismatching the backup catalog directory with catalog metainformation when manually moving a catalog file.
  • Qbackup: Paths in catalog meta information are now always absolute.
  • Qbackup: Errors during backup are now always reflected in backup status.
  • QCP: qcp, and qcp-ctrl now return a non-zero exit code when errors occur.

QHB Version 1.2.0 Release Notes

Added

  • QHB 2B: QHB extensions to support 1C. The 1C:Enterprise platform is supported starting from version 8.3.18.
  • The qhb_upgrade utility provides database migration from previous QHB versions and PostgreSQL version 12.
  • Support for Fedora 33 distributions.

Improved

  • The functionality of the existing packages in the Alt Server 9 distribution has been checked.

QHB Version 1.1.0 Release Notes

QHB Plan Cache

Experimental feature is disabled by default, it has been added to test stability and functionality.

New feature

QHB Bootstrap

Base initialization system, functional analogue of initdb, completely redesigned to take into account the features of QHB.

New feature

QSS

Secure storage module (encryption with support for the “Kuznechik” cryptographic algorithm).

  • QSS has been replenished with the functions qhb_get_qss_tables and qhb_get_qss_indexes.
  • Improved output in case of error.
  • A new mode of working with a parallel set of keys has been added, qss_recrypt with command for fetching encrypted tables and their indexes.
  • Support for base64-encoding keys, “Kuznechik” in CTR mode has been added.
  • rbytea support has been added.
  • The QSS Pinpad utility has been added.
  • RuToken support has been added.

QSQL

User interactive utility for working from the command string.

  • Support for \password and \include meta-commands.

Append Only Storage

This storage only allows you to add records, but does it with maximum speed, since a full MVCC analysis is not performed.

Intended for tables that are not modified, for example, logs, sensor data, etc.

New feature

QBackup

A new backup and recovery subsystem with support for catalog, backup archiving and saving a “difference” instead of a full backup has been added.

QDL

Added

  • QDL parallel operation mode.
  • User documentation.
  • Demo configuration file in RPM package.

Changed

  • In order to create a database, you no longer need the result of working with the DBMS.
  • Support for basic types has been stabilized.
  • Work with pages and tuples has been reworked to improve stability.
  • The recording API in all QDL components has been standardized.

Corrected

  • A number of system functions, the operation of which led to the recording of incorrect tuple sizes into page metainformation.

Utilities

  • qhb_archivecleanup: dependencies have been updated and Russian localization has been added.
  • qhb_checksum: parallel operation mode and normal output of progress bar with the --verbose flag have been added.
  • qhb_checksum: now works correctly with large files.
  • The createdb utility has been implemented.
  • The dropdb utility has been implemented.

Metrics

Collection and presentation subsystem for external display of system metrics. Currently provided only in grafana.

  • Metrics have been added to the TARQ buffer manager.
  • grafana no longer initializes execution time for each call with_grafana.
  • Flipping the buffer "clock" back when changing the system clock.

Other improvements

  • The TARQ buffer manager has been optimized.
  • Debug symbols have been removed from the release build.
  • Build parameters that caused poor performance have been fixed.
  • Implementation of a checkpointer in Rust.
  • Many annoying restrictions have been removed and critical errors have been eliminated.

Copyright © KVANTOM LLC, 2019-2026