PL/Ruby is a procedural-language handler that lets you write database functions in Ruby, stored and executed inside PostgreSQL. You get the expressiveness of Ruby and its standard library with the full power of a native PostgreSQL function: plain functions, set-returning functions, triggers, event triggers, and procedures with transaction control. ```sql CREATE EXTENSION plruby; CREATE FUNCTION he…
The PostgreSQL Global Development Group announces that the second beta release of PostgreSQL 19 is now available for download. This release contains PostgreSQL 19 feature previews ahead of general availability, though some details of the release can change during the beta period. You can find information about all of the PostgreSQL 19 features and changes in the release notes: https://www.postgres…
We are excited to announce a new release of the Odyssey — advanced multi-threaded connection pooler for PostgreSQL and Apache Cloudberry. A lot of new small features have been implemented, alongside extended protocol support refactoring - many violations fixed, and overall performance of pipelining improved. New features: simple shared pools support pool_pin_on_listen option for transaction poolin…
Tainan, Taiwan - Sun 12 Jul 2026 powa-archivist 5.2.0 The PoWA team is pleased to announce the release of the version 5.2.0 of powa-archivist, the core extension of the PoWA project. PoWA (PostgreSQL Workload Analyzer) is a performance tool, compatible with all supported PostgreSQL versions. It allows to collect and aggregate metrics gathered from multiple PostgreSQL instances using various extens…
Autobase 2.9 focuses on the next step in the platform's evolution: simplifying PostgreSQL infrastructure management after deployment. See the full details in the release notes. Highlights Platform users & email/password authentication Added support for platform users and email/password authentication. Each user can now sign in with their own credentials instead of using a shared access token. The…
PDU helps recover offline PostgreSQL databases by reconstructing metadata, exporting tables, and reading WAL for targeted row recovery. When a PostgreSQL instance cannot be started, normal SQL tools are no longer available. PDU, PostgreSQL Data Unloader, is an open source recovery tool for that situation. It reads PostgreSQL data files and WAL archives directly, without modifying the original data…
🚀 Announcing pglayers Pre‑built PostgreSQL extensions as composable Docker image layers Project: https://github.com/pglayers/pglayers 📌 What It Does pglayers publishes 53 PostgreSQL extensions as minimal Docker images (FROM scratch). Each image contains only: Shared libraries Control files SQL scripts Correct filesystem paths You compose them onto the official postgres Docker image using COPY --fr…
We are pleased to announce the release of Barman 3.19.0 and 3.19.1, which shipped in quick succession on May 20 and May 26, 2026. This announcement covers both releases. Barman (Backup and Recovery Manager) is an open-source administration tool for remote backups and disaster recovery of PostgreSQL servers in business-critical environments. It relies on PostgreSQL's point-in-time recovery technolo…
What's Changed use openssl 3.5.5 by @davecramer in https://github.com/postgresql-interfaces/psqlodbc/pull/169 Fix SQLPrimaryKeys to exclude INCLUDE columns from results by @davecramer in https://github.com/postgresql-interfaces/psqlodbc/pull/171 Fix stack buffer overflow in getPrecisionPart() (GitHub #173) by @davecramer in https://github.com/postgresql-interfaces/psqlodbc/pull/174 Avoid reading p…
POSETTE: An Event for Postgres 2026, took place from 16–18 June 2026 as a free and virtual event, organized by Microsoft in partnership with AMD. Although the event has concluded, all the content remains available online. All 44 talks are now on YouTube Whether you missed the conference or want to revisit your favorite sessions, all 44 talks are now available on YouTube, with captions that have be…
IVM Development Group is pleased to announce the release of pg_ivm 1.15. Changes since the v1.14 release include: What's Changed New features Add IMMV metadata restore support for pg_dump and pg_upgrade (Yugo Nagata) After restoring a database from pg_dump or upgrading PostgreSQL using pg_upgrade, IMMVs no longer need to be dropped and recreated manually. The new pg_ivm_dump_metadata utility and r…
The CloudNativePG Community is excited to announce the immediate availability of CloudNativePG 1.30.0! This minor release introduces the new DatabaseRole CRD for declarative, GitOps-friendly PostgreSQL role management and a Lease-based primary election primitive for safer failover, alongside notable security and operational improvements, further cementing CloudNativePG as the leading operator for…
Silent channel-binding authentication downgrade (CVE-2026-54291) channelBinding=require connections can be silently downgraded from SCRAM-SHA-256-PLUS (with channel binding) to plain SCRAM-SHA-256 (without it), losing the man-in-the-middle protection the setting is meant to guarantee. An attacker who can intercept the TLS connection triggers the downgrade with a certificate whose signature algorit…
Bangkok, Thailand - June 17, 2026 PostgreSQL DBMS_LOCK compatibility extension PostgreSQL extension to manages advisory locks in a way compatible to Oracle DBMS_LOCK package. This extension uses PostgreSQL advisory locks to emulate the same behavior following the lock mode (exclusive or shared), the timeout and the on commit release settings. pg_dbms_lock v2.0 has been released, this is a maintena…
Bangkok, Thailand - June 21, 2026 PostgreSQL credcheck extension The credcheck PostgreSQL extension provides few general credential checks, which will be evaluated during the user creation, during the password change and user renaming. By using this extension, we can define a set of rules: allow a specific set of credentials reject a certain type of credentials deny password that can be easily cra…
Core Features git Repo: https://github.com/burnside-project/pg-cdc pg-cdc is not just replication. pg-cdc streams Postgres Write Ahead Logs(WAL) out of production Postgres into typed, immutable, time-travelable Iceberg tables on S3 Registers each entities in the AWS Glue Catalog Gates every read with AWS Lake Formation tags — so AI agents, analysts, and query engines consume governed data without…
Bangkok, Thailand - June 23, 2026 PostgreSQL DBMS_ERRLOG compatibility extension The pg_dbms_errlog extension provides the infrastructure that enables you to create an error logging table so that DML operations can continue after encountering errors rather than abort and roll back. It requires the use of the pg_statement_rollback extension or to fully manage the SAVEPOINT in the DML script. Loggin…
Bangkok, Thailand - June 21, 2026 PostgreSQL Global Temporary Tables pgtt is a PostgreSQL extension to create, manage and use DB2 or Oracle-style Global Temporary Tables. Once created the use is just like with the other RDBMS. pgtt v4.5 has been released, this is a maintenance release to add support to PG 19 and add support to CREATE INDEX CONCURRENTLY. and fix issues reported by users since last…
PGDay UK is back on September 8 2026, held at the Cavendish Conference Centre in London, UK. Our schedule is up: https://pgday.uk/events/pgdayuk2026/schedule/. We have 7 great speakers with 7 great talks. Registration is also open: https://2026.pgday.uk/registration/. Early bird tickets are available until July 31, 2026 (or until they are sold). See you in London in September! PGDay.UK 2026 organi…
Dear Community, We are pleased to announce the release of IvorySQL 5.4, based on PostgreSQL 18.4. This release includes IvorySQL skills, a browser-based online trial environment, and a wider range of supported extensions. IvorySQL 5.4 Highlights: PostgreSQL 18.4 Foundation: IvorySQL 5.4 upgrades its kernel to PostgreSQL 18.4, inheriting all of the corresponding upstream fixes. IvorySQL Skills: Emp…
Offers read and write access to hot and cold storage with no application code changes, delivering up to 90% savings in storage ALEXANDRIA, Va., June 18, 2026 — pgEdge, the leading open source enterprise Postgres company, today announced pgEdge ColdFront, a transparent data tiering solution for PostgreSQL. Unlike other alternatives, ColdFront’s cold tier is fully writable: UPDATE and DELETE work on…
Taipei, Taiwan - Sat 20 Jun pg_stat_kcache 2.3.2 The PoWA team is pleased to announce the release of the version 2.3.2 of pg_stat_kcache, an extension that gathers statistics about real reads and writes done by the filesystem layer and CPU usage. Changelog Miscellaneous Add postgres 19 compatibility (Georgy Shelkovy, Julien Rouhaud) Fix installation command on RHEL/Rocky/Alma (Pierre Forstmann) Li…
Taipei, Taiwan - Sat 20 Jun pg_qualstats 2.1.4 The PoWA team is pleased to announce the release of the version 2.1.4 of pg_qualstats, a PostgreSQL extension keeping statistics on predicates found in WHERE statements and JOIN clauses. Changelog Bugfix: Teach joins about joinqual attribute (Julien Rouhaud, thanks to Tatsuro Yamada for the report) Miscellaneous: Add support for PostgreSQL 19 (Georgy…
PGX is pleased to announce PGX Longevity, a service providing critical security patches and data integrity bug fixes for versions of PostgreSQL no longer receiving community releases, from 9.6 to 13 (and version 14 after the last release in November). Many installations are running older version of PostgreSQL that they cannot upgrade for a variety of reasons, but still require maintanence. PGX Lon…
Built on tree-sitter-postgres, postgres-lsp implements the Language Server Protocol for PostgreSQL SQL and PL/pgSQL. Point your editor at it for .sql files and get diagnostics, navigation, completion, and formatting backed by real PostgreSQL grammar rather than regex heuristics. Features Diagnostics — Parse errors from tree-sitter reported as LSP diagnostics Semantic Tokens — Syntax highlighting v…
Taipei, Taiwan - Sat 20 Jun HypoPG 1.4.3 I'm pleased to announce the release of the version 1.4.3 of HypoPG, an extension adding support for Hypothetical Indexes, compatible with PostgreSQL 9.2 and above. Changelog Bug fixes: Fix long standing Int8GetDatum bugs (Julien Rouhaud) Misc: Add support for PostgreSQL 19 (Julien Rouhaud) Links & Credits Thank to the users who reported bugs, they are all c…
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.16. This release of pgAdmin 4 includes 64 bug fixes and new features, including fixes for seven security vulnerabilities (CVE-2026-12044 through CVE-2026-12050). For more details, please see the release notes. pgAdmin is the leading open-source graphical management tool for PostgreSQL. For more information, plea…