With this release, pgAssistant is evolving beyond PostgreSQL analysis and tuning to become a continuous PostgreSQL improvement platform. The new positioning is built around a continuous improvement loop: Observe → Diagnose → Prioritize → Plan → Implement → Collect again → Measure pgAssistant already helped identify what should be improved and turn recommendations into a prioritized Executive Plan…
CERN PGDay 2027 Date: Friday, February 12, 2027 Location: CERN Campus, Geneva, Switzerland / Suisse Romande Language: English Organizers: Swiss PostgreSQL Users Group (SwissPUG) & CERN Format: Single-track (6–7 sessions) followed by networking social event Homepage: swisspug.org/cern-pgday-2027 About the Event Continuing in the line of work of the past editions, CERN PGDay 2027 returns as the annu…
pg_vault_tde provides Transparent Data Encryption for PostgreSQL 17 and 18. A table access method, encrypted_heap, encrypts every tuple with AES-256-GCM before it reaches the storage manager and decrypts it after it leaves, so applications require no changes. Keys are held outside the database: HashiCorp Vault or OpenBao through the Transit engine, a PKCS#11 token or HSM, or a local PKCS#12 wallet…
Paris, 7th september 2026. The Dalibo team is pleased to announce the release of PostgreSQL Migrator 1.0 stable, a free and open-source tool designed to help migrate databases from Oracle and MySQL/MariaDB to PostgreSQL. Key features Easy installation: pure Go binary with zero proprietary dependencies. Fast, offline inspection: Extract the full source catalog once, then iterate on conversion offli…
Autobase 2.11 is an important milestone in the evolution of the platform. Two years ago, we started working on a broader goal: evolve the Autobase Console from a PostgreSQL deployment UI into a platform for managing the complete cluster lifecycle. With this release, the remaining major pieces of that roadmap are now in place - scaling, upgrades, backups, and point-in-time recovery can all be manag…
Eymoutiers, France, Septembre 4th, 2026 Dalibo is pleased to announce PostgreSQL Anonymizer 3.2 introducing a new panel of fast pseudonymization filters. Enhanced Privacy Protection for Your Data PostgreSQL Anonymizer is an extension that hides or replaces personally identifiable information (PII) or commercially sensitive data from a PostgreSQL database. The extension offers 6 different masking s…
Hey there, Mark your calendars: PGConf India 2027 is set for March 2–5, 2027 at the Sheraton Grand Hotel at Brigade Gateway, Bengaluru. The Call for Papers is open right now. Important dates CFP closes — October 15, 2026 We tell you yes/no — November 15, 2026 The actual conference — March 2–5, 2027 What we're into Basically anything Postgres, including but not limited to: Core internals & features…
Just in time for the PostgreSQL 19 betas, I'm excited to announce release 1.2 of pg_statviz, the minimalist extension and utility pair for time series analysis and visualization of PostgreSQL internal statistics. This release adds support for the upcoming PostgreSQL 19: pg_statviz now captures the new wal_fpi_bytes counter from pg_stat_wal. The PG18/19 I/O worker, effective WAL level, and autovacu…
LibreDB Studio is an MIT-licensed, self-hosted SQL IDE for PostgreSQL that runs in the browser and deploys as a container or Helm chart. It is deployed next to the database it manages, as a container, a Helm chart or an npm package, rather than installed on each developer's machine. PostgreSQL is its reference implementation: the provider is built on node-postgres, and the other supported engines…
We have a new architecture on apt.postgresql.org: Loongson loong64, a Chinese processor architecture. The build host for the architecture is running on a Loongson 3B6000 board provided by the loongfans.cn community. Bootstrapping the PostgreSQL packages was completed earlier this month and everything is in place to be used via apt.postgresql.org. The exception is the GIS stack of packages (postgis…
Tainan, Taiwan - Sun 16 Aug 2026 powa-archivist 5.3.0 The PoWA team is pleased to announce the release of the version 5.3.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…
The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 18.6, 17.11, 16.15, 15.19, and 14.24, as well as the third beta release of PostgreSQL 19. This release fixes 28 security vulnerabilities and over 110 bugs reported over the last several months. This release skips PostgreSQL 18 versions from PostgreSQL 18.4 to 18.6. 18.5 was not shipped…
What plx is plx is a PostgreSQL extension that lets you write stored functions and triggers in the dialect you already know (the current set is listed below). When you run CREATE FUNCTION, plx transpiles the body to plpgsql and stores that plpgsql in pg_proc.prosrc. At run time the function is executed by PostgreSQL's own plpgsql interpreter. There is no separate language runtime loaded into the b…
Dear Community Members, We are excited to announce the release of SynchDB 1.4, a PostgreSQL extension for real-time replication from heterogeneous source databases into PostgreSQL/IvorySQL. This release extends Oracle Container Database support to every Oracle replication path, allows snapshot connections to be encrypted, and improves stability under sustained replication load. What's New in Synch…
Sehrope Sarkini along with Claude has written a new JDBC driver from scratch. It's currently in pre-release. Here's an excerpt from his blog PostgreSQL-first. The native API is designed around PostgreSQL's wire protocol and feature set. It is not designed around the lowest common denominator that JDBC has to support across every database on earth. If PostgreSQL can do it, the API should be able to…
Dasha is an open source performance dashboard for PostgreSQL fleets. It connects to your clusters with a read-only role, shows what the databases are doing right now, and explains what to do about it. Nothing is installed on the database hosts: no agent, no extension beyond the ones you already have. One instance serves many clusters and all of their replicas. Because most PostgreSQL statistics ar…
Autobase 2.10 expands day-to-day PostgreSQL operations with new cluster management capabilities. Administrators can now perform common cluster actions directly from the Console UI, configure advanced system settings, deploy clusters using the local disk, and automate maintenance with an extended set of Ansible playbooks. See the full details in the release notes. Highlights Cluster management acti…
Hi all, The talk schedule for Postgres Summit US 2026 is now published. Browse it here: Talk Schedule The summit runs September 30 through October 2, 2026 at Convene, 555 Broadway, New York, NY, organized by the United States PostgreSQL Association (PgUS). You can also view individual sessions and register on the event site. Hope to see you in New York!
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.17. This release of pgAdmin 4 includes 28 bug fixes and new features, including fixes for seven security vulnerabilities (CVE-2026-17346 through CVE-2026-17351, and CVE-2026-17566). For more details, please see the release notes. pgAdmin is the leading open-source graphical management tool for PostgreSQL. For mo…
We are very glad to announce the E-Maj 5.0.0 version. Among improvements, this major version: Allows non-superuser roles to install and use E-Maj in a database, the usable features depending on the priviledges they own. Eases writing idempotent administration scripts and managing E-Maj parameters. Brings the PostgreSQL 19 version compatibility. The Emaj_web client has been enhanced too, in particu…
July 30, 2026: The pgBackRest community is pleased to announce the release of pgBackRest 2.59.0, the latest version of the reliable, easy-to-use backup and restore solution that can seamlessly scale up to the largest databases and workloads. pgBackRest supports a robust set of features for managing your backup and recovery infrastructure, including: parallel backup/restore, full/differential/incre…
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…