ADB 7 releases

Added support for Astra Linux SE 1.8.4 (Orel and Voronezh) and RED OS 8.0

Monitoring is now based on Prometheus and Grafana. Greengage Exporter is now supported

ADBM and ADB Control are moved to a separate bundle, ADB Enterprise Services (ADB ES). The process of upgrading to a new ADB version is described in Migration of ADB Control and ADBM metadata during ADB ES installation

Implemented a new service, PgBouncer

Implemented a new cluster action, Manage Rebalance

Added support for LDAPS

Added support for reading and writing Iceberg-format data in Hive Metastore and REST catalogs (starting with PXF 6.16.0)

The release is based on Greengage DB 7.5.0

The release includes PXF 6.17.5

For the Expand cluster action, added support for Wizard, which is available in ADCM version 2.10.1 and higher

Added the ability to choose a password hashing algorithm (MD5 or SCRAM-SHA-256) using the Hash algorithm parameter in the ADB service configuration

ADCM minimum version is 2.12

Added OS version compatibility checks to the Install, Reinstall, and Upgrade cluster actions. The actions will fail if the OS version is unsupported

Implemented ADBM 2.8.1

Implemented ADB Control 4.15.1

The Move Host Segment, Expand, and Init Standby Master cluster actions reboot only new hosts now

Fixed an issue with switching to the standby coordinator when using the force activation mode

Fixed an issue where the ADB to ADB connector could hang during parallel retrieve cursor closure

Fixed an issue where reading from a foreign table within a transaction could fail

Fixed an issue with dispatching DROP commands to segments when the object is missing on the coordinator

Fixed an issue where temporary files could remain in the system if a query with a materialized CTE was interrupted by an error

The release includes the following components: ADBM, ADB Control, and connectors (ADB ClickHouse, ADB to Kafka and Kafka to ADB, ADB to ADB). Offline installation is supported

Migrated ADB to Greengage DB

DBeaver has been adapted to work with Greengage DB. Use version 25.2.3 or later

Added support for Linux cgroup v2, allowing you to limit disk throughput

Implemented orphaned file cleanup

Added the ability to define a distribution key for Redistribute Motion when using foreign tables

Added support for LDAP authentication

Added support for LLVM 18

Implemented TLS options for PXF external tables and foreign data wrappers (FDWs)

Implemented ADBM 2.8.0

Implemented ADB Control 4.15.0

Refactored arenadata_toolkit. The extension has been aligned with the latest Greengage DB architecture, and several components have been reorganized with part of the functionality moved into the gp_toolkit extension

Implemented a precheck to ensure a standby coordinator cannot be added when mirroring is not enabled

Refactored OS parameter handling and added a precheck to validate required system settings

Added support for selecting group or spread mirroring

Added SSL support for connections between pxf_fdw and the PXF service

Enabled support for the DEXTRA_DYNAMIC_MEMORY_DEBUG macro

Disallowed inlining of CTEs containing DML operations

Raised a planner error for SELECT INTO queries containing modifying CTEs

Enabled JSON output for EXPLAIN ANALYZE statistics

Prevented WAL removal during recovery when archive_mode=always

Added an explicit error when specifying ENCODING for foreign-table columns

Added EXPLAIN ANALYZE statistics for queries with DML inside CTEs

Added a default transformation flag for gpfdist applied automatically when a table has no transformation level defined

Ensured gpcloud compatibility with OpenSSL 1.1.1

Added a check to ensure the previous expand action completed successfully before starting the next one

Fixed an issue where temporary schemas were not cleaned up after segment failures

Fixed an issue where pg_dump generated an invalid DROP EXTERNAL TABLE statement that prevented proper restoration

Fixed gplogfilter so that time-range filters correctly skip irrelevant files

Fixed an issue where disk space was not promptly reclaimed after dropping temporary tables

Fixed an issue where GUCs on segments were not updated when running gpstop -u

Fixed a crash when running EXPLAIN (ANALYZE, FORMAT JSON) for gp_toolkit.gp_table_size_skew_coefficients()

Fixed an issue where inserts failed if default_tablespace pointed to a non-existing tablespace

Fixed incorrect calculation of space used by spill files when multiple processes run in the same session

Fixed an issue where VACUUM could corrupt the bitmap index of an AO table on mirror segments

Fixed an issue where LDAP connections ignored hostssl and did not use SSL for the specified users

Fixed an issue preventing the use of wildcard characters in interconnect addresses

Fixed an issue in the tablefunc extension that prevented using DML queries

Fixed incorrect memory allocation when generating statistics for hash join queries

MADlib is now delivered as an extension

The output of the EXPLAIN command in JSON mode has been fixed to provide more accurate query execution details

GPDB compilation will now fail if compiler warnings occur, improving build quality

Implemented error reporting for invalid operations involving CTEs in the SELECT INTO statements

Interruption of LDAP requests by signals will no longer be treated as an authentication error, enhancing stability

Official support for Ubuntu 22.04 on x86-64 platform has been added

The query analysis logic has been moved to the PostgreSQL core, improving performance and integration

Simplified the dbid detection logic to improve the reliability of the pg_rewind command

Optimized the row counting mechanism in replicated tables for DML operations

Updated the data distribution logic to ensure proper handling of combined hash specifications

Python 3.11 is now supported, enhancing container operations

Updated the CTE processing mechanism to always materialize data if it is used outside of SELECT

Incorporated the latest timezone data updates for more accurate time zone management

Updated JIT support to enhance query performance in GPDB

Added documentation for running JIT tests and updated LLVM support to the latest versions

Fixed Dockerfile for proper execution of the GPDB 7 test suite and added support for Java 11

Resolved resource leaks during errors while executing the COPY TO/FROM PROGRAM commands

Addressed compilation warnings to improve compatibility with modern compilers

Corrected an issue that occurred when switching the access method to columnar for tables

Resolved an issue that caused a segmentation fault when calculating compression ratios for AO tables

Resolved an issue where temporary schemas were not properly cleaned up after segment failures

Addressed errors related to incorrect row access during the analysis of AOCO tables

The gpstop -u command logic has been updated to ensure that GUC parameters are properly applied on segments