A.1. Postgres Pro Shardman 14.19.1 #
Release date: 2025-10-15
This release is based on PostgreSQL 14.19 and Shardman 14.18.3 and provides new features, optimizations and bug fixes. Major changes are as follows:
A.1.1. Core and Extensions #
Allowed displaying statistics on size of the
MT_SPImessage components (bytes) sent from the node with theshardman.pg_stat_silk_msg_componentsview.Updated the behavior while planning: if a prepared statement connects to a generic plan that cannot be pruned effectively, then another planning and comparison with a custom plan occur.
Updated the supported version of pgpro_pwr to 4.10.
Updated the supported version of pg_proaudit to 2.0.
A.1.2. Management Utilities #
Updated the etcd client version to 3.6.4.
Updated the
shardmanctl statuscommand that now can show status of a cluster in standby mode.Guaranteed the data consistency when forming user lists.
Added new configuration parameters to work with syncpoints:
syncpointIntervalthat allows specifying how often is a syncpoint created (in seconds),syncpointEnabledthat enablesmonitorthat periodically creates syncpoints, andsyncpointLimitthat specifies the amount of the most recent syncpoints stored.Added new configuration parameters to work with a standby cluster:
intervalWalReceiveCheck,intervalLSNFinder,intervalWalApply,intervalCheckLSN,timeoutApplyLSN,intervalWalSyncArbiter.Added a feature of a cluster restart with minimum downtime by means of the
shardmanctl restart rollingcommand.Updated the replication slot configuration that is now configured on a node level of a standby.
Disabled coloring of the log level when executing any
shardmanctlcommand.Lifted a limitation, now global and sharded tables can be created during a backup process.
Fixed a bug that resulted in
panicduring the rebalance process.Fixed an issue that could result in instances restart due to a short connection loss with etcd.
Fixed an issue the the
waitingindicator not being displayed.Fixed the BDU:2025-02344 and GHSA-fv92-fjc5-jj9h vulnerabilities.
Fixed the GO-2025-3770 vulnerability.
Fixed a bug that previously resulted in adding new nodes failure if the
shardmanschema had global tables with data or global sequences.Fixed the
shardmanctl backupissue, now does not create an invalid backup, as its execution stops on every shard if any error occurs.