PGSYS 3.1.0 Highlights
Get to know the highlights of each component of PostgreSYS 3.1.0:
| Component | Version | Highlights |
|---|---|---|
| PgSmart | 3.1.0 | Inclusion of the Observability service with Prometheus and Grafana integrated and several panels and graphs for all components of the PostgreSYS platform. |
| Inclusion of PostGIS for integrated support for spatial data. | ||
| Greater adherence to existing environments with the recognition of installed binaries and initialized database instances. | ||
| Support for SUSE operating system (openSUSE Leap and SLES). | ||
| Support for PostgreSQL 16. | ||
| PostgreSQL | 16.2 | Enables parallelization of full and internal hash joins of type RIGHT OUTER . |
| Enables logical replication from standby servers. | ||
| Allows logical replication subscribers to apply large transactions in parallel. | ||
| Allows monitoring I/O statistics using the new pg_stat_io view. | ||
| Adds SQL/JSON constructors and identity functions. | ||
| Improves vacuum freezing performance. | ||
| Adds support for regular expression matching in pg_hba.conf and pg_ident.conf files. | ||
| pgBackRest | 2.51 | Added Enhanced support for dual stack connections. |
| Meson as the main build system. | ||
| Added Detection of files that did not change during non-delta incremental backup. | ||
| Added Prevention of invalid recovery when backup_label is removed. | ||
| Improved handling of the WAL segment queue in archive-push. | ||
| Limits resume functionality to full backups. | ||
| Updated resume functionality for block increment. | ||
| Allows --version and --help options. | ||
| PgBouncer | 1.22.1 | Added support for DEALLOCATE ALL and DISCARD ALL when max_prepared_statements is set to a non-zero value (normal DEALLOCATE is still not supported). |
| Added Support for configuring auth_query per Database. | ||
| Made fast failover logic able to handle all scenarios where there are no more working connections to the database and none can be established. | ||
| Documentation improvements. | ||
| Patroni | 3.3.0 | Added support for JSON log format. |
| Shows pending_restart_reason information. | ||
| Provides detailed information about PostgreSQL parameters that caused the pending_restart flag to be set. | ||
| Implements the nostream tag. | ||
| Implements log section validation. | ||
| Improves logging of changes to PostgreSQL parameters. | ||
| etcd | 3.5.12 | Fixes non-validation of database consistency index and crash on null backend. |
| Fixes unnecessary locking of snapshot files on delete. | ||
| HAProxy | 2.9.6 | Performance and flexibility improvements with HTTP/2, threads, shared pools, logs, health checks, maps, cache, stick tables and QUIC. |
| More flexibility with syslog load balancing, more QUIC options, more SSL/TLS libraries, new experimental interaction between data center load balancers and edge load balancers that we call "Reverse HTTP", and much more. | ||
| New hash type for custom hash-based load balancing, new functions for working with Proxy Protocol TLV fields, more cache options, more Lua options and new converters. | ||
| PostGIS | 3.4.2 | Complete manual internationalization. |
| Target version support in postgis_extensions_upgrade. | ||
| Exposes GEOS version at compile time. | ||
| New install-extension-upgrades command in postgis script. | ||
| Support for changes to PostgreSQL 16. | ||
| PROJ pipelines support. | ||
| RenameTopology, RenameTopoGeometryColumn. | ||
| Support for adding min/max resampling as options. | ||
| Support for casting topogeometry to topoelement. | ||
| Allows singleton geometry to be inserted into Geometry(Multi*) columns. | ||
| New window-based functions ST_ClusterWithinWin and ST_ClusterIntersectingWin. | ||
| Debug_standardize_address function. | ||
| ST_LargestEmptyCircle, exposes extra semantics in the search for circles. Requires GEOS 3.9+. | ||
| ST_Project signature for geometry and two-point signature. | ||
| ST_LineExtend to extend linestrings. | ||
| New coverage functions ST_CoverageInvalidEdges, ST_CoverageSimplify, ST_CoverageUnion. | ||
| Prometheus | 2.51.2 | Relabel of rules for the AlertManagerConfig, making it possible to route alerts to different Alertmanager instances. |
| Addition of the histogram_avg function to the Prometheus Query Language (PromQL). | ||
| Performance improvements for OpenTelemetry operations. | ||
| Grafana | 10.4.2 | Support for styles for geomap geojson layers. |
| Support for subtables through the grouping feature for transformations into nested tables. | ||
| Rule-based access control (RBAC) for the library panel. | ||
| Button to return to previous context. | ||
| Alertmanager | 0.27.0 | UTF-8 support. |
| Addition of new counters, such as alertmanager_alerts_supressed_total which tracks silenced alerts and contains a label to indicate the reason for silencing. | ||
| Improvements in integrations with Discord and Microsoft Teams. | ||
| Karma | 0.120 | UTF-8 support. |
| Karma no longer uses the alertmanager api/v2/status to discover cluster peers, only the parameters defined in the configuration file. |