E.2. Release Notes for Tantor BE 16.2.1#

E.2. Release Notes for Tantor BE 16.2.1

E.2. Release Notes for Tantor BE 16.2.1 #

Release date: 2024-08-01

E.2.1. Review #

Tantor BE is a Russian-made DBMS based on the updated and improved version of the PostgreSQL DBMS. Tantor BE 16.2.1 is based on PostgreSQL 16.

Below are the additional modules and utilities added to Tantor BE, as well as a list of changes to the server core.

E.2.2. DBMS Core Functionality #

The following changes have been made to improve the DBMS:

  • Additional meta information about the publication and assembly information has been added to the pg_controldata server application to simplify the diagnosis of possible problems.

  • The database server logs are more informative: the database start messages now contain additional diagnostic information.

  • An improvement has been added to diagnose internal database errors: the inclusion of the backtrace_on_internal_error parameter, which records a stack trace for XX000 errors.

  • Optimized the operation of the SLRU cache to improve performance.

  • The maximum size of data in table cells supported by the pg_dump module has been increased from 1 GB to 2 GB.

E.2.3. Additional Supplied Modules #

  • Added the pgl_ddl_deploy extension to send DDL commands to the slave server during logical replication.

  • A number of improvements have been made to the pg_stat_statements extension to optimize the operation of Tantor Planform.

  • Improved pgauditlogtofile extension:

    • Version updated to 1.6.2.

    • Added rotation by file size.

  • Added support for the Tantor pipelinedb extension, including:

    • Support for partitioning functionality has been implemented.

    • Critical segmentation errors and build warnings have been fixed.

E.2.4. Fixes for Additional Supplied Modules #

E.2.5. Additional Supplied Programs #

The pg_anon program has been improved:

  • Multi-stage debugging mode is implemented.

  • New parameters have been added and the functionality of existing parameters has been expanded.

E.2.6. Supported Operating Systems #

The list of supported operating systems (OS) has been expanded. The full list is provided below:

  • Altlinux c9f2 (P8)

  • Altlinux p10

  • AstraLinux 1.7

  • AstraLinux 1.8

  • AstraLinux 2.12

  • AstraLinux 4.7 (arm64)

  • Centos 7

  • Debian 10 Buster

  • Debian 11 Bullseye

  • Debian 12 Bookworm

  • MSVSphere

  • Oracle Linux 8

  • Redos 7.3

  • Redos 8

  • Rocky 8

  • Rocky 9

  • Ubuntu 18

  • Ubuntu 20

  • Ubuntu 22

DBMS builds are created and tested for these operating systems on an ongoing basis.

E.2.7. Migration to version 16.2.1 #

To migrate from PostgreSQL or Tantor DB, first install the latest minor version and then perform a data offload/restore by applying 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.2. Parameter Name Changes

Tantor DB 15Tantor DB 16Status
commit_ts_bufferscommit_timestamp_bufferschanged
serial_buffersserializable_bufferschanged
subtrans_bufferssubtransaction_bufferschanged
xact_bufferstransaction_bufferschanged
multixact_members_buffersmultixact_members_buffersunchanged
multixact_offsets_buffersmultixact_offsets_buffersunchanged
notify_buffersnotify_buffersunchanged