E.4. Release Notes for Tantor SE 16.6.0#
E.4. Release Notes for Tantor SE 16.6.0 #
Release date: 2024-12-12
E.4.1. Review #
Tantor SE is a Russian-made DBMS based on the updated and improved version of the PostgreSQL DBMS. Tantor SE 16.6.0 is based on PostgreSQL 16.
Below are the additional modules and utilities added to Tantor SE, as well as a list of changes to the server core.
E.4.2. Additional Supplied Programs #
Added extensions:
pg_archive — allows you to automatically archive historical data from partitioned tables.
pg_throttle — allows you to limit the speed of query execution.
pg_trace — provides an opportunity for in-depth analysis and profiling of SQL queries, which is especially relevant for users of the 1C platform.
pg_uuidv7 — provides support for working with the UUIDv7 data type.
Updated extensions:
credcheck — to version 2.8
hypopg — to version 1.4.1
orafce — to version 4.13.3
pg_background — to version 1.3
pg_cron — to version 1.6.4
pg_hint_plan — to version 1.6.1
pg_qualstats — to version 2.1.1
pg_repack — to version 1.5.1
pg_store_plans — to version 1.8
pg_variables — to version 1.2.5
pg_wait_sampling — to version 1.1.6
pgaudit — to version 17.0
pgauditlogtofile — to version 1.6.2
pgq — to version 3.5.1
E.4.3. Fixes for Additional Supplied Modules #
Fixed
set_access_methodfor schemas that not publicFixed overflow of the loop variable in the
IsCreateTableAsfunction.
E.4.4. Migration to version 16.6.0 #
When upgrading within the current major version and edition, install Tantor SE 16.6.0 and restart the database server with command:
systemctl restart tantor-se-server-16
To migrate from PostgreSQL or Tantor DB, first install the latest minor version and then perform a data dump/restore using pg_dumpall, or use the pg_upgrade utility.
Additionally, to migrate from a PostgreSQL database with the Citus Columnar extension to a PostgreSQL database with the Hydra Columnar extension, you can use the columnar_migrator script, which ensures data integrity and compatibility.
Tantor DB version 16 uses new naming conventions for SLRU cache size parameters.
To migrate from version 15 to version 16 with respect to SLRU cache size parameters,
use the script upgrade-SLRU-from-TT_15-to-TT_16-version.sh.
The script is installed in /opt/tantor/db/16/tools/slru_upgrader/.
For script usage, please define the PGDATA variable, which should
specify the path to the cluster data directory of the migration target version (16).
Help information is also available with the command /opt/tantor/db/16/tools/slru_upgrader/upgrade-SLRU-from-TT_15-to-TT_16-version.sh --help.
The following table summarizes the changes in parameter names from Tantor DB 15 to
Tantor DB 16:
Table E.4. Parameter Name Changes
| Tantor DB 15 | Tantor DB 16 | Status |
|---|---|---|
| commit_ts_buffers | commit_timestamp_buffers | changed |
| serial_buffers | serializable_buffers | changed |
| subtrans_buffers | subtransaction_buffers | changed |
| xact_buffers | transaction_buffers | changed |
| multixact_members_buffers | multixact_members_buffers | unchanged |
| multixact_offsets_buffers | multixact_offsets_buffers | unchanged |
| notify_buffers | notify_buffers | unchanged |