A.1. Postgres Pro Shardman 14.18.2 #

Release date: 2025-06-16

This release is based on PostgreSQL 14.18 and Shardman 14.18.1 and provides new features, optimizations and bug fixes. Major changes are as follows:

A.1.1. Core and Extensions #

  • Renamed the is_reply field of the shardman.silk_routing view to is_outgoing. The field value is true if the route was produced by the outgoing network connection, false for incoming network connections.

  • Updated the default values for logging configuration parameters for all new Shardman installations:

    • logging_collector: on

    • log_directory: {{dataDir}}

    • log_filename: postgres-{{cluster}}-{{shard}}-{{host}}-{{keeperID}}.log

  • Fixed an issue that previously caused the shardman.execute_query function failure if a non-builtin attribute type was used.

A.1.2. Management Utilities #

  • Added an additional check for pg_probackup execution to ensure the current primary nodes did not switch during the cluster backup, otherwise it aborts the execution.

  • Changed the default values for the -t (--transactions) and -T (--time) flags of the shardmanctl bench run command to 10 and 0, respectively.

  • Optimized promotion of a standby server to primary.

  • Fixed a bug that previously resulted in pg_ basebackup hanging. Now during resynchronization replication slots are created on the primary node automatically if the standby node lags behind.