•   PostgreSQL

Postgres Pro Standard 17.5.1 Released

Source:
Postgres Pro Team Subscribe to blog
Source:
Postgres Pro Team Subscribe to blog

Postgres Professional has issued updates for Postgres Pro Standard. Versions 13.21.1, 14.18.1, 15.13.1, 16.9.1 and 17.5.1 are now available for download and upgrade from the official repository.

 

Below is an overview of the fixes and enhancements that have been updated or newly introduced for 17.5.1 users.

 

New Solutions:


Among the key additions are: daterange_inclusive, pg_probackup3, pgpro_bindump, and pgpro_tune.

pgpro_tune — rapid automatic performance tuning.

The pgpro_tune utility simplifies a DBA’s work by automatically collecting information about the current hardware and generating an optimal PostgreSQL configuration file based on it. It is now integrated into the database initialization process (initdb), making it easier—even for inexperienced administrators—to quickly configure a database server for specific hardware.

 

pg_probackup3 — the next generation of backup solutions.

With this release, the fully redesigned backup and restore solution—pg_probackup3—is now available. Its advantages include:

  • Version independence — a single pg_probackup3 release is compatible with multiple Postgres Pro and PostgreSQL versions;

  • API integration — simplifies incorporating backup operations into your existing infrastructure;

  • Data transfer without SSH — requires no additional SSH setup and enhances security;

  • Incremental copying — support for DELTA and PTRACK modes dramatically reduces the time and storage needed for backups;

  • Improved backup management — the new backup format generates a fixed number of archive files for easier storage, rather than mirroring PGDATA contents as-is.

pg_probackup3 is recommended for enterprises that value fast database recovery and seamless integration with their existing technology stack.

pgpro_bindump — a module for simplified backup and replication.

The new pgpro_bindump replication-protocol module is designed specifically to work with pg_probackup3 and brings several improvements to backup and replication:

  • Built-in WAL file transfer alongside data files, eliminating the risk of data loss;

  • Archiving data files in CBOR format, which optimizes storage and boosts performance.

pgpro_bindump streamlines integration, simplifies backup management, and enhances the reliability of the backup process.

daterange_inclusive — addressing the upper-bound exclusion in date ranges.

PostgreSQL’s built-in daterange type excludes its upper bound by default, which can complicate tasks such as calculating employee leave dates—forcing you to manually adjust the end date when displaying results. The daterange_inclusive extension solves this by allowing you to explicitly include the upper bound of a date range. This makes working with any calendar intervals more intuitive and error-proof.

Module Updates

Postgres Pro Standard 17.5.1 includes many additional enhancements:

  • Parallel queries on temporary tables. Offers potentially significant performance gains for complex queries that use temporary tables.

  • Crash_info improvements. Provides more complete and accurate failure diagnostics, including process start time, the query text at planning time, and fixes in stack traces—greatly simplifying troubleshooting.

Updated modules:

  • AQO 3.1 — enhancements to adaptive query optimization, including a knowledge-base aggregation for similar queries.

  • pg_proaudit — new object types and event fields (UUID, XID, VXID), plus fixes for more precise and comprehensive auditing.

  • pg_probackup 2.8.9 — updated backup utility with new commands (maintain), improved stability, and performance.

  • pgpro_pwr 4.9 and pgpro_stats 1.9 — enhanced statistics collection, performance monitoring, and session tracing, giving DBAs even more tools for analysis and optimization.

Expanded OS support — adds MosOS 15 and Ubuntu 25.04.

← Back to all articles