# PostgreSQL news

PostgreSQL news

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## PostgreSQL 19 Released!

DevFeed: [PostgreSQL 19 Released!](<https://devfeed.tech/articles/postgresql-19-released-144026.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/postgresql-19-released-3449/>)

Author: PostgreSQL Global Development Group

Published: 2026-11-19T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [rdbms](<https://devfeed.tech/topics/rdbms.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [Data Management](<https://devfeed.tech/topics/data-management.md>), [database-scalability](<https://devfeed.tech/topics/database-scalability.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [administration](<https://devfeed.tech/tags/administration.md>), [database](<https://devfeed.tech/tags/database.md>), [developer](<https://devfeed.tech/tags/developer.md>), [development](<https://devfeed.tech/tags/development.md>), [disruption](<https://devfeed.tech/tags/disruption.md>), [extensibility](<https://devfeed.tech/tags/extensibility.md>), [extension](<https://devfeed.tech/tags/extension.md>), [features](<https://devfeed.tech/tags/features.md>), [global](<https://devfeed.tech/tags/global.md>), [global-development](<https://devfeed.tech/tags/global-development.md>), [network](<https://devfeed.tech/tags/network.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [open-source-community](<https://devfeed.tech/tags/open-source-community.md>), [operations](<https://devfeed.tech/tags/operations.md>), [optimize](<https://devfeed.tech/tags/optimize.md>), [organizations](<https://devfeed.tech/tags/organizations.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-19](<https://devfeed.tech/tags/postgresql-19.md>)

### AI overview

PostgreSQL 19 adds ways to manage and observe busy workloads with less disruption. `REPACK (CONCURRENTLY)` reclaims table bloat and can reorder data without blocking reads or writes; `pg_plan_advice` stabilizes or experiments with query plans, while `pg_stash_advice` can apply saved advice by query identifier without application changes. Autovacuum gains parallel index vacuuming and table-priority scoring, alongside new monitoring views and I/O reporting. For replication, creating the first logical replication slot automatically raises the effective WAL level to `logical`; `WAIT FOR LSN` lets standby sessions wait for replay before reading recent primary writes. Developer additions include `INSERT ... ON CONFLICT DO SELECT` for get-or-create behavior and JSON output from `COPY`. The release also adds TLS SNI certificate selection, warns after successful MD5 authentication, and removes RADIUS support. JIT is disabled by default because its cost estimates proved unreliable; users running many large analytical queries may choose to enable it.

### Source excerpt

November 19, 2026 - The PostgreSQL Global Development Group today announced the release of PostgreSQL 19, the latest version of the world's most advanced open source database. Mission-critical usage of PostgreSQL continues to rapidly rise, and PostgreSQL 19 responds to this by simplifying both administration and development for these workloads at scale. This release introduces the REPACK (CONCURRENTLY) command so users can optimize tables for their current workload without disruption to ongoing operations. PostgreSQL 19 gives users better control over plan stability and query performance with the new pg_plan_advice extension. Developers will find many delightful features in this release, from support for "read-your-writes" consistency on standbys to "get or create" behavior that saves a network round trip. "For over 30 years, the global open source community has built PostgreSQL into a database that organizations trust with their most critical data," said Jonathan Katz, a member of the PostgreSQL core team. "PostgreSQL 19 continues that commitment to reliability, giving users new ways to manage their workloads without disruption and to build applications that span multiple systems." PostgreSQL, an innovative data management system known for its reliability, robustness, and extensibility, benefits from 30 years of open source development from a global developer community and has become the preferred open source relational database for organizations of all sizes. Simplifying workload management Tables that receive many updates and deletes can build up unused space, known as "bloat," which can also significantly impact query performance. The VACUUM FULL and CLUSTER commands were previously used to handle this, but had tradeoffs, including preventing access to the table until the cleanup finished. PostgreSQL 19 introduces the REPACK command, which reclaims this space and can reorder a table's data to match an index, and with REPACK (CONCURRENTLY), can do so without bloc

## pgjumbo: a new free desktop client for PostgreSQL

DevFeed: [pgjumbo: a new free desktop client for PostgreSQL](<https://devfeed.tech/articles/pgjumbo-a-new-free-desktop-client-for-postgresql-141065.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pgjumbo-a-new-free-desktop-client-for-postgresql-3444/>)

Published: 2026-11-18T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [AppImage](<https://devfeed.tech/topics/appimage.md>)

Tags: [administration](<https://devfeed.tech/tags/administration.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [analyze](<https://devfeed.tech/tags/analyze.md>), [apple-silicon](<https://devfeed.tech/tags/apple-silicon.md>), [archive](<https://devfeed.tech/tags/archive.md>), [arm64](<https://devfeed.tech/tags/arm64.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [backup](<https://devfeed.tech/tags/backup.md>), [changes](<https://devfeed.tech/tags/changes.md>), [client](<https://devfeed.tech/tags/client.md>), [completion](<https://devfeed.tech/tags/completion.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [contents](<https://devfeed.tech/tags/contents.md>), [cron](<https://devfeed.tech/tags/cron.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [deb](<https://devfeed.tech/tags/deb.md>), [desktop](<https://devfeed.tech/tags/desktop.md>), [free](<https://devfeed.tech/tags/free.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

pgjumbo is a free desktop client for PostgreSQL 12+ on Windows, macOS, and Linux, including Amazon Aurora and RDS with IAM authentication. It can connect directly, over SSL, or through an SSH tunnel. Version 1.0.2 combines schema inspection, a query tool with completion and EXPLAIN views, and a data editor that previews statements before saving. Backup and restore use PostgreSQL's pg_dump tools and support selecting objects or rows, inspecting archive contents, and restoring to a new database. Maintenance tools cover VACUUM, ANALYZE, REINDEX, and per-table autovacuum settings. Object changes are shown as SQL for review; destructive statements on servers marked Production require confirmation.

### Source excerpt

pgjumbo is a new desktop client for PostgreSQL 12+, free to use, for Windows, macOS and Linux, with query, data and administration tools. pgjumbo connects to PostgreSQL 12+, including Amazon Aurora and RDS with IAM authentication, directly, over SSL or through an SSH tunnel. Installers are available for Windows (x64 and ARM64), macOS (Apple silicon and Intel) and Linux (AppImage, .deb and .rpm). Version 1.0.2 includes: An object explorer and inspector with each object's CREATE script, statistics and dependencies. A Query Tool with completion, syntax errors from PostgreSQL's own parser as you type, parameters, EXPLAIN as a table or a diagram, and results that can be sorted, filtered, compared and exported. A data editor that shows the statements before it saves them. Backup and restore built on pg_dump, pg_dumpall and pg_restore: choosing objects and rows, server backups as a folder of archives, reading an archive's contents before restoring, and restoring into a new database. Maintenance: what each table needs and what holds VACUUM back, VACUUM, ANALYZE and REINDEX as reviewed steps with progress, and autovacuum settings per table. Server activity, configuration, roles and privileges, logs, replication, pg_cron jobs and LISTEN/NOTIFY. Changes to objects are shown as SQL and reviewed before they run, and on servers marked Production, destructive statements ask for confirmation first. Download pgjumbo - Release notes for 1.0.2

## WAL-G 3.0.10 released

DevFeed: [WAL-G 3.0.10 released](<https://devfeed.tech/articles/wal-g-3-0-10-released-141067.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/wal-g-3010-released-3448/>)

Published: 2026-11-18T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [releases](<https://devfeed.tech/topics/releases.md>), [backups](<https://devfeed.tech/topics/backups.md>), [read-replica](<https://devfeed.tech/topics/read-replica.md>), [MariaDB](<https://devfeed.tech/topics/mariadb.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [Redis](<https://devfeed.tech/topics/redis.md>)

Tags: [accounting](<https://devfeed.tech/tags/accounting.md>), [apache-cloudberry](<https://devfeed.tech/tags/apache-cloudberry.md>), [aws-sdk](<https://devfeed.tech/tags/aws-sdk.md>), [backup](<https://devfeed.tech/tags/backup.md>), [backup-and-recovery](<https://devfeed.tech/tags/backup-and-recovery.md>), [backup-storage](<https://devfeed.tech/tags/backup-storage.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [copy](<https://devfeed.tech/tags/copy.md>), [greenplum](<https://devfeed.tech/tags/greenplum.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [object-storage](<https://devfeed.tech/tags/object-storage.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [redis](<https://devfeed.tech/tags/redis.md>), [release](<https://devfeed.tech/tags/release.md>), [replication](<https://devfeed.tech/tags/replication.md>), [restore](<https://devfeed.tech/tags/restore.md>), [s3](<https://devfeed.tech/tags/s3.md>), [v2](<https://devfeed.tech/tags/v2.md>)

### AI overview

WAL-G 3.0.10 adds `wal-send`, which serves archived WAL through PostgreSQL's streaming replication protocol so standbys and `pg_receivewal` can read from object storage and follow new segments. `backup-push --wait-for-archive` waits for required WAL segments to reach the selected backup storage before marking a backup complete. The release also adds AWS SDK v2 S3 support with configurable timeouts, retryable errors, and checksums, plus optional server-side S3 copying and configurable transfer concurrency. Greenplum and Cloudberry updates include shared-storage accounting and fixes to segment backup, restore, and copy. Permanent backups remain protected from retention-based deletion, but an explicit delete target can remove them.

### Source excerpt

The WAL-G team is pleased to announce the release of WAL-G 3.0.10. WAL-G is an open-source backup and recovery tool for PostgreSQL, Apache Cloudberry, MySQL/MariaDB, MongoDB, Redis, and other databases. The main new PostgreSQL feature is wal-send. It serves archived WAL over PostgreSQL's streaming replication protocol, allowing standbys and pg_receivewal to read WAL directly from object storage and follow new segments as they arrive. Other PostgreSQL improvements include: Continuous WAL archival in daemon mode: the pipeline keeps working between requests, and retained lookahead reduces directory scanning (#2697, #2698). Optional backup-push --wait-for-archive: WAL-G waits for all WAL segments required by the backup to reach the selected backup storage before publishing the backup as complete (#2722). Backup-name reservation before upload, protecting against concurrent reuse of the same name (#2707). WAL prefetch files are published only after a successful download (#2696), and WAL source files are closed after upload failures (#2695). Standard X/X LSN notation in catchup-push --from-lsn (#2643). S3 support now uses AWS SDK v2 and adds configurable request timeouts, retryable error codes, and checksum settings. Backup copying can use server-side S3 copy and configurable transfer concurrency. Greenplum and Cloudberry improvements include per-backup accounting for shared AO/AOCS/PAX storage and fixes to segment backup, restore, and copy operations. One behavior change to note: permanent backups remain protected from retention-based deletion, but an explicit delete target can now remove them (#2808). WAL-G v3.0.10 is available for download, along with the full release notes, on our GitHub releases page. Have a nice day!

## pgSherpa: a free PostgreSQL monitoring companion for macOS

DevFeed: [pgSherpa: a free PostgreSQL monitoring companion for macOS](<https://devfeed.tech/articles/pgsherpa-a-free-postgresql-monitoring-companion-for-macos-141066.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pgsherpa-a-free-postgresql-monitoring-companion-for-macos-3446/>)

Published: 2026-11-18T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [infrastructure monitoring](<https://devfeed.tech/topics/infrastructure-monitoring.md>), [macOS](<https://devfeed.tech/topics/macos.md>), [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>)

Tags: [app-store](<https://devfeed.tech/tags/app-store.md>), [apple-silicon](<https://devfeed.tech/tags/apple-silicon.md>), [companion](<https://devfeed.tech/tags/companion.md>), [desktop](<https://devfeed.tech/tags/desktop.md>), [free](<https://devfeed.tech/tags/free.md>), [intel](<https://devfeed.tech/tags/intel.md>), [keychain](<https://devfeed.tech/tags/keychain.md>), [locks](<https://devfeed.tech/tags/locks.md>), [macos](<https://devfeed.tech/tags/macos.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [pg-stat-statements](<https://devfeed.tech/tags/pg-stat-statements.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [screen](<https://devfeed.tech/tags/screen.md>), [server](<https://devfeed.tech/tags/server.md>), [servers](<https://devfeed.tech/tags/servers.md>), [statement](<https://devfeed.tech/tags/statement.md>), [telemetry](<https://devfeed.tech/tags/telemetry.md>), [transaction](<https://devfeed.tech/tags/transaction.md>), [write](<https://devfeed.tech/tags/write.md>)

### AI overview

pgSherpa is a free macOS desktop companion that polls PostgreSQL 12-18 servers and surfaces issues with explanatory text and supporting rows. It offers a SQL box with server-version-specific `\h` help, plus reports for activity, locks, query statistics, vacuum progress, indexes, and replication. Statements run in read-only transactions unless switched to write. Setup requires a role with `pg_monitor`; no server extension or agent is installed. The excerpt says credentials stay in the macOS Keychain and that the app has no account or telemetry. It supports macOS 12 or later on Apple silicon and Intel Macs.

### Source excerpt

CortexRidge has released pgSherpa, a free desktop companion for PostgreSQL on macOS, now available on the Mac App Store. pgSherpa sits in a corner of the screen and polls one or more PostgreSQL servers (PostgreSQL 12 to 18). When something needs attention it says so in a sentence, with the rows behind it: Health: lock-wait chains, long-running and idle-in-transaction sessions, replication lag and replication slots, vacuum and transaction ID wraparound, connection limits. Security: the server's version compared with the latest PostgreSQL minor release and the CVEs fixed since, plus configuration such as SSL, MD5 passwords and superuser count. Cloud: backups, failovers, maintenance windows and replicas for DigitalOcean Managed Databases, Supabase and Amazon RDS / Aurora PostgreSQL, read from the provider's API. SQL: a query box with PostgreSQL completion and \h syntax help for the server's own version. Every statement runs in a read-only transaction unless the user switches it to write. Reports: ready-made views of pg_stat_activity, pg_locks, pg_stat_statements, vacuum progress, indexes and replication. pgSherpa needs only a role with pg_monitor. It installs no extension and no agent on the server, and it has no account and no telemetry; passwords and keys stay in the macOS Keychain. It runs on macOS 12 or later, on Apple silicon and Intel Macs. Mac App Store: https://apps.apple.com/app/id6833955115 More information: https://cortexridge.com/

## Navicat Introduces Navicat 18 for PostgreSQL: Experience Enterprise-Grade PostgreSQL Database Management and Development

DevFeed: [Navicat Introduces Navicat 18 for PostgreSQL: Experience Enterprise-Grade PostgreSQL Database Management and Development](<https://devfeed.tech/articles/navicat-introduces-navicat-18-for-postgresql-experience-enterprise-grade-postgresql-database-management-and-development-137835.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/navicat-introduces-navicat-18-for-postgresql-experience-enterprise-grade-postgresql-database-management-and-development-3441/>)

Author: PremiumSoft Cyber Tech Ltd

Published: 2026-11-17T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [Tool](<https://devfeed.tech/topics/tool.md>), [rdbms](<https://devfeed.tech/topics/rdbms.md>), [data-modeling](<https://devfeed.tech/topics/data-modeling.md>), [AI Integration Strategies](<https://devfeed.tech/topics/ai-integration-strategies.md>), [data-governance](<https://devfeed.tech/topics/data-governance.md>), [User Interfaces](<https://devfeed.tech/topics/user-interfaces.md>)

Tags: [administration](<https://devfeed.tech/tags/administration.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-integration](<https://devfeed.tech/tags/ai-integration.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-redshift](<https://devfeed.tech/tags/amazon-redshift.md>), [azure](<https://devfeed.tech/tags/azure.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [cloud-based](<https://devfeed.tech/tags/cloud-based.md>), [cloud-sql](<https://devfeed.tech/tags/cloud-sql.md>), [code](<https://devfeed.tech/tags/code.md>), [complex](<https://devfeed.tech/tags/complex.md>), [data](<https://devfeed.tech/tags/data.md>), [data-masking](<https://devfeed.tech/tags/data-masking.md>), [data-types](<https://devfeed.tech/tags/data-types.md>), [database](<https://devfeed.tech/tags/database.md>), [database-management](<https://devfeed.tech/tags/database-management.md>), [dependencies](<https://devfeed.tech/tags/dependencies.md>), [development](<https://devfeed.tech/tags/development.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

Navicat 18 for PostgreSQL adds AI-assisted data editing and table design, SQL editing aids including symbol renaming and real-time syntax checks, and data masking with substitution, variance, shuffling, hashing, and nulling. Its modeling tools combine logical entities and physical constraints in a Hybrid Model, with naming standards, a glossary, and bulk table editing. BI additions include automatic dashboard tiling, global parameters, page navigation, and auto refresh. Usability changes include a Parquet-capable import wizard with previews, batch editing, and a record navigation panel; profile sync and session history are also included. The announcement says it supports on-premises and cloud databases, including the listed PostgreSQL services, and offers purchase and a 14-day trial.

### Source excerpt

Navicat, a leading provider of powerful database management and development software, is proud to unveil Navicat 18 for PostgreSQL, an innovative release that sets a new standard in PostgreSQL administration and development. Designed to simplify the complexities of managing on-premises and cloud-based PostgreSQL servers--including Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Amazon Redshift, Microsoft Azure Database for PostgreSQL, Google Cloud SQL for PostgreSQL, and Fujitsu Enterprise Postgres--Navicat 18 for PostgreSQL introduces cutting-edge features and GUI enhancements that empower developers and database administrators to achieve unmatched efficiency and productivity. Key New Features in Navicat™ 18 for PostgreSQL - AI Integration: Brings intelligent automation directly to the Data Editor and Table Designer. Users can populate, translate, and analyze columns in seconds with Fill with AI, or design PostgreSQL tables effortlessly using Ask AI, which defines columns and data types while automatically generating table summaries through Fill with Comment. - Query Editing & Code Insight: Elevating code precision right inside the SQL Editor. Users can restructure complex queries effortlessly without breaking dependencies using Refactoring (Rename Symbol). Furthermore, the editor constantly analyzes scripts with Real-Time Error Detection to pinpoint syntax flaws, while Hover Info, Highlight Usages, and Go to Declaration uncover related items instantly. - Data Masking: Secures sensitive production data for safe, compliant testing by transforming sensitive PostgreSQL records into realistic mock data. Supports industry-standard masking techniques including Substitution, Variance, Shuffling, Hashing, and Nulling. - Model: Unifying conceptual design and physical structures. The new Hybrid Model maintains logical entities and physical constraints in a single workspace. Organizations can automatically enforce architectural consistency via Naming Standards & Glossa

## pg\_fastload 1.0.0 released: parallel bulk loading for PostgreSQL

DevFeed: [pg\_fastload 1.0.0 released: parallel bulk loading for PostgreSQL](<https://devfeed.tech/articles/pg-fastload-1-0-0-released-parallel-bulk-loading-for-postgresql-137837.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pg_fastload-100-released-parallel-bulk-loading-for-postgresql-3445/>)

Author: Pg Fastload

Published: 2026-11-17T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [CSV](<https://devfeed.tech/topics/csv.md>), [IO](<https://devfeed.tech/topics/io.md>)

Tags: [backend](<https://devfeed.tech/tags/backend.md>), [background](<https://devfeed.tech/tags/background.md>), [cache](<https://devfeed.tech/tags/cache.md>), [column](<https://devfeed.tech/tags/column.md>), [copy](<https://devfeed.tech/tags/copy.md>), [core](<https://devfeed.tech/tags/core.md>), [csv](<https://devfeed.tech/tags/csv.md>), [data](<https://devfeed.tech/tags/data.md>), [encoding](<https://devfeed.tech/tags/encoding.md>), [export](<https://devfeed.tech/tags/export.md>), [faster](<https://devfeed.tech/tags/faster.md>), [fields](<https://devfeed.tech/tags/fields.md>), [file](<https://devfeed.tech/tags/file.md>), [filter](<https://devfeed.tech/tags/filter.md>), [fork](<https://devfeed.tech/tags/fork.md>), [format](<https://devfeed.tech/tags/format.md>), [function](<https://devfeed.tech/tags/function.md>), [loading](<https://devfeed.tech/tags/loading.md>), [parallel](<https://devfeed.tech/tags/parallel.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

pg_fastload 1.0.0 parallelizes reading, parsing, and tuple formation across background workers while the issuing backend serially inserts rows, keeping the load in one transaction. A single reader scans the file once and sends chunks to parser workers, so total input read remains one file size. It is a source-level fork of pg_bulkload 3.1.23 and preserves its control-file syntax, TYPE values, log format, and WRITER modes. The parallel path falls back automatically, with an INFO message, for unsupported conditions including FILTER, explicit ENCODING, constraints, PARSE_ERRORS tolerance, STDIN, and TUPLE or FUNCTION input. In the cited 1 GiB CSV test, default 15-worker pg_fastload took 1.37 seconds versus 5.81 seconds serial pg_fastload, 6.98 seconds for upstream pg_bulkload's fastest mode, and 8.32 seconds for COPY FROM. Results depend on the reported workload and hardware; the excerpt also describes progress reporting, snapshot-auditable exports, and optional index dropping during loads.

### Source excerpt

pg_fastload 1.0.0 is a parallel bulk loader for PostgreSQL, 1.58x faster than the best pg_bulkload mode and 6.07x faster than COPY. It parallelises the loading pipeline across background workers while keeping the load inside a single transaction. It is a source-level fork of pg_bulkload 3.1.23, so control-file syntax, TYPE values, log format and WRITER modes are unchanged. Repository: github.com/yuansong/pg_fastload Release: pg_fastload v1.0.0 License: BSD 3-Clause, with the upstream pg_bulkload copyright notices retained The problem pg_bulkload and COPY both run the whole load in one backend: read, parse, form the tuple, write. On a 16-core machine that leaves 15 cores idle, and the parse step is usually the expensive one. For CSV it is a byte-at-a-time state machine followed by a type input function per column. How it works The load has four stages: read input, parse record and split fields, form the tuple, and insert. Stages 1-3 move to background workers; stage 4 stays serial in the backend that issued the load: one reader worker -> N parser workers -> leader writes Design points that matter in practice: The input file is read exactly once. A single reader scans sequentially and hands chunks to the workers over shm_mq; the workers never open the file. Total read volume stays at 1x the file size, so the speedup does not invert once the data is larger than the page cache. It is still one transaction. No second connection, no early visibility of uncommitted rows, and a bad row aborts the whole load rather than leaving a worker-timing-dependent subset behind. 13 conditions the parallel path cannot honour fall back automatically, with one INFO line saying why: FILTER and FORCE_NOT_NULL, explicit ENCODING, NOT NULL or CHECK constraints, PARSE_ERRORS tolerance, STDIN input, TUPLE and FUNCTION input, and others. The serial path itself was optimised. Records without quotes or CRs take a memchr bulk split instead of the byte-at-a-time loop. Progress reporting and export E

## PG\_CVE 1.1.1 Released

DevFeed: [PG\_CVE 1.1.1 Released](<https://devfeed.tech/articles/pg-cve-1-1-1-released-137836.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pg_cve-111-released-3443/>)

Author: Meob PostgreSQL Tools

Published: 2026-11-17T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [Tool](<https://devfeed.tech/topics/tool.md>), [common vulnerabilities and exposures](<https://devfeed.tech/topics/common-vulnerabilities-and-exposures.md>)

Tags: [announce](<https://devfeed.tech/tags/announce.md>), [client](<https://devfeed.tech/tags/client.md>), [common-vulnerabilities-and-exposures](<https://devfeed.tech/tags/common-vulnerabilities-and-exposures.md>), [cve](<https://devfeed.tech/tags/cve.md>), [cves](<https://devfeed.tech/tags/cves.md>), [exploit](<https://devfeed.tech/tags/exploit.md>), [exploits](<https://devfeed.tech/tags/exploits.md>), [features](<https://devfeed.tech/tags/features.md>), [highlights](<https://devfeed.tech/tags/highlights.md>), [integration](<https://devfeed.tech/tags/integration.md>), [interface](<https://devfeed.tech/tags/interface.md>), [lightweight](<https://devfeed.tech/tags/lightweight.md>), [navigation](<https://devfeed.tech/tags/navigation.md>), [overview](<https://devfeed.tech/tags/overview.md>), [patch](<https://devfeed.tech/tags/patch.md>), [planning](<https://devfeed.tech/tags/planning.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rapid](<https://devfeed.tech/tags/rapid.md>), [release](<https://devfeed.tech/tags/release.md>), [security](<https://devfeed.tech/tags/security.md>)

### AI overview

PG_CVE 1.1.1 is a lightweight standalone web interface for PostgreSQL security and release review. It associates security advisories and CVEs with specific PostgreSQL versions, includes known exploit data for vulnerability triage, and presents stability and patch information to support upgrade planning. The supplied excerpt does not specify changes unique to version 1.1.1.

### Source excerpt

We are pleased to announce the release 1.1.1 of PG_CVE, a lightweight tool designed to provide DBAs and system administrators with a clear, up-to-date overview of CVEs (Common Vulnerabilities and Exposures), known exploits, and release stability across PostgreSQL versions. Key Features & Highlights: Rapid tracking of security advisories and CVEs associated with specific PostgreSQL versions. Overview of release stability and patch information to assist DBAs with upgrade planning. Security context: integration of known exploit data for accurate vulnerability triage. Lightweight, standalone web interface for fast client-side navigation. Links & Resources: Live Interactive Demo: https://meob.github.io/PG_CVE/?version=15.8 Source Code & Documentation: https://github.com/meob/PG_CVE

## PostgreSQL 18.7, 17.12, 16.16, 15.20, 14.25, and 19 RC 2 Released!

DevFeed: [PostgreSQL 18.7, 17.12, 16.16, 15.20, 14.25, and 19 RC 2 Released!](<https://devfeed.tech/articles/postgresql-18-7-17-12-16-16-15-20-14-25-and-19-rc-2-released-130929.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/postgresql-187-1712-1616-1520-1425-and-19-rc-2-released-3442/>)

Author: PostgreSQL Global Development Group

Published: 2026-11-12T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [code security](<https://devfeed.tech/topics/code-security.md>), [Access Control](<https://devfeed.tech/topics/access-control.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [2026](<https://devfeed.tech/tags/2026.md>), [about](<https://devfeed.tech/tags/about.md>), [after](<https://devfeed.tech/tags/after.md>), [all](<https://devfeed.tech/tags/all.md>), [alter](<https://devfeed.tech/tags/alter.md>), [backup](<https://devfeed.tech/tags/backup.md>), [bug](<https://devfeed.tech/tags/bug.md>), [bug-fixes](<https://devfeed.tech/tags/bug-fixes.md>), [bugs](<https://devfeed.tech/tags/bugs.md>), [can](<https://devfeed.tech/tags/can.md>), [candidate](<https://devfeed.tech/tags/candidate.md>), [cast](<https://devfeed.tech/tags/cast.md>), [change](<https://devfeed.tech/tags/change.md>), [changes](<https://devfeed.tech/tags/changes.md>), [code](<https://devfeed.tech/tags/code.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-18](<https://devfeed.tech/tags/postgresql-18.md>), [postgresql-19](<https://devfeed.tech/tags/postgresql-19.md>), [rc](<https://devfeed.tech/tags/rc.md>)

### AI overview

PostgreSQL updates 18.7, 17.12, 16.16, 15.20, and 14.25 fix 52 security vulnerabilities and more than 140 bugs; PostgreSQL 19 RC 2 includes applicable fixes. PostgreSQL 14.25 is the final PostgreSQL 14 release, after which it receives no further security or bug fixes. Minor updates can be applied by stopping PostgreSQL and replacing its binaries, without a dump/reload or pg_upgrade. Check for affected indexes: reindex pg_trgm GiST indexes, indexes on bpchar columns without a declared length, and indexes implicated by GIN corruption or "missing chunk number" errors. Incremental-backup users should take a new full backup as the basis for future incrementals. Partitioned tables may need NOT NULL NO INHERIT constraints checked and repaired. PostgreSQL 19 RC 2 is a pre-release; moving to it from an earlier major version requires pg_upgrade or dump/restore, and some full-text search, pg_trgm, and fuzzystrmatch indexes may need reindexing. The excerpt also identifies PostgreSQL 19 RC 1 issues that can prevent pg_upgrade from recreating certain test objects.

### Source excerpt

The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 18.7, 17.12, 16.16, 15.20, and 14.25, as well as the second release candidate of PostgreSQL 19. This release fixes 52 security vulnerabilities and over 140 bugs reported over the last several months. There are several issues that may require you to take extra steps after updating, which are described in detail below. See the "Updating" section for more information on post-update steps you may need to take. For the full list of changes, please review the release notes. PostgreSQL 14 EOL Notice This is the final release of PostgreSQL 14. PostgreSQL 14 is now end-of-life and will no longer receive security and bug fixes. If you are running PostgreSQL 14 in a production environment, we suggest that you make plans to upgrade to a newer, supported version of PostgreSQL. Please see our versioning policy for more information. Security Issues The following security vulnerabilities are closed in this update release. You can find more details about the vulnerabilities and their affected versions in the links below: CVE-2026-6460: Type confusion after ALTER ... SET DATA TYPE executes arbitrary code (CVSS v3.1: 8.8) CVE-2026-6467: Extension script schema mishandling executes arbitrary SQL (CVSS v3.1: 7.2) CVE-2026-14661: dblink and subscriptions can append to arbitrary files (CVSS v3.1: 8.1) CVE-2026-16237: INSERT ... ON CONFLICT can read or modify rows despite auto-updatable view WHERE condition (CVSS v3.1: 5.4) CVE-2026-16240: pg_basebackup can use backup manifest content as a format string (CVSS v3.1: 3.7) CVE-2026-18447: Output parameter type confusion executes arbitrary code (CVSS v3.1: 8.8) CVE-2026-116303: Foreign key and JSON conversions bypass EXECUTE privilege on cast functions (CVSS v3.1: 3.1) CVE-2026-116304: Parallel RECORD typmod use-after-free executes arbitrary code (CVSS v3.1: 8.8) CVE-2026-116306: Composite-type change during field assignment execut

## Dasha 1.10: Patroni auto-discovery, wait analysis and replication slot forecasts for PostgreSQL

DevFeed: [Dasha 1.10: Patroni auto-discovery, wait analysis and replication slot forecasts for PostgreSQL](<https://devfeed.tech/articles/dasha-1-10-patroni-auto-discovery-wait-analysis-and-replication-slot-forecasts-for-postgresql-124190.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/dasha-110-patroni-auto-discovery-wait-analysis-and-replication-slot-forecasts-for-postgresql-3438/>)

Published: 2026-11-09T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [patroni](<https://devfeed.tech/topics/patroni.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [analysis](<https://devfeed.tech/tags/analysis.md>), [discovery](<https://devfeed.tech/tags/discovery.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [patroni](<https://devfeed.tech/tags/patroni.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>)

### AI overview

Dasha 1.10 adds Patroni discovery through read-only etcd v3 or Consul access, linking standby clusters to their upstream by PostgreSQL system identifier. Its Activity & Waits view (PostgreSQL 14+) samples pg_stat_activity every 1-10 seconds and groups active sessions by CPU, wait type and idle-in-transaction; filters and links connect results to query reports and lock trees. It also forecasts replication slot loss from WAL rate measured over a chosen 30-second to 5-minute window, and adds COPY progress reporting. Health Score time series can use stock Prometheus exporters, and inactive tables no longer lower scores for dead rows or missing vacuum by default after seven days. Monitored databases require PostgreSQL 14+ and a role with pg_monitor and CONNECT on each database; Activity & Waits also requires compute_query_id enabled or auto with pg_stat_statements or pgpro_stats preloaded.

### Source excerpt

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, and no extension beyond the ones you already have. One instance serves many clusters and all of their replicas. Most PostgreSQL statistics are per-instance and are not replicated, so Dasha reads every host of a cluster and reasons over the combined picture. An index that looks unused on the primary may be serving the entire read workload on a standby. New since the last announcement Patroni clusters from etcd v3 or Consul. Dasha reads the keys Patroni keeps in its DCS and turns every Patroni scope into a cluster: the members become hosts and the databases are listed from PostgreSQL. New clusters, lost replicas, created and dropped databases show up within the refresh interval. The DCS is only read, never written. User, password, port and database filters can be overridden per scope, and TLS with client certificates is supported for both etcd and Consul. Member names appear in the host selector next to the address. Standby cluster links. A Patroni standby cluster shows the cluster it replicates from, and the primary shows its standbys, on the Summary and Replication pages. Clusters are matched by the PostgreSQL system identifier, so a standby behind a VIP is found too. Activity & Waits (PostgreSQL 14+). A live chart of active sessions by class: CPU, wait event type (IO, Lock, LWLock, ...) and idle in transaction, sampled from pg_stat_activity every 1-10 seconds. Below it are the top statements, sessions, databases, users, applications and wait events; a click on a value adds a filter, and a statement links to its query report and the lock tree. Statements are grouped by query_id. No extension is needed, and each Dasha instance reads a host's pg_stat_activity at most once per second however many people watch the page.

## AgensGraph 2.18 Released: Graph Database on PostgreSQL 18 with Expanded ISO GQL Support

DevFeed: [AgensGraph 2.18 Released: Graph Database on PostgreSQL 18 with Expanded ISO GQL Support](<https://devfeed.tech/articles/agensgraph-2-18-released-graph-database-on-postgresql-18-with-expanded-iso-gql-support-122263.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/agensgraph-218-released-graph-database-on-postgresql-18-with-expanded-iso-gql-support-3437/>)

Author: SKAI Worldwide

Published: 2026-11-07T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [graph-database](<https://devfeed.tech/topics/graph-database.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [17](<https://devfeed.tech/tags/17.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [b-tree](<https://devfeed.tech/tags/b-tree.md>), [call](<https://devfeed.tech/tags/call.md>), [collect](<https://devfeed.tech/tags/collect.md>), [count](<https://devfeed.tech/tags/count.md>), [cypher](<https://devfeed.tech/tags/cypher.md>), [database](<https://devfeed.tech/tags/database.md>), [delete](<https://devfeed.tech/tags/delete.md>), [exists](<https://devfeed.tech/tags/exists.md>), [filter](<https://devfeed.tech/tags/filter.md>), [gql](<https://devfeed.tech/tags/gql.md>), [graph](<https://devfeed.tech/tags/graph.md>), [graph-database](<https://devfeed.tech/tags/graph-database.md>), [index](<https://devfeed.tech/tags/index.md>), [insert](<https://devfeed.tech/tags/insert.md>), [iso](<https://devfeed.tech/tags/iso.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-18](<https://devfeed.tech/tags/postgresql-18.md>), [support](<https://devfeed.tech/tags/support.md>)

### AI overview

AgensGraph 2.18.6.1 adds an initial set of ISO GQL clauses alongside openCypher and changes variable-length traversals to use the edge label's index at each hop. In the team's test on the 30-million-edge soc-Pokec graph, a two-hop query that took over 20 seconds without finishing on 2.17 completed in milliseconds on 2.18. The release also adds graph subqueries and PostgreSQL function calls via CALL ... YIELD. It is based on PostgreSQL 18.6 and includes typed property columns and security changes for Cypher writes and fixed-length patterns. A 2.17 data directory cannot be used directly: upgrade with pg_upgrade or dump and restore using 2.18's pg_dump. The supplied text is partial, so it does not support a complete account of all release features.

### Source excerpt

The AgensGraph Development Team is pleased to announce the release of AgensGraph v2.18.6.1, the latest version in the 2.18 series. AgensGraph is an open-source graph database, built on PostgreSQL 18.6, that runs SQL and graph queries over the same data, in the same transaction and even in the same statement. AgensGraph 2.18 is a major step toward the ISO GQL standard (ISO/IEC 39075), the international standard query language for property graphs. We are committed to bringing AgensGraph in line with GQL: 2.18 adds the first set of GQL clauses alongside openCypher, and more will follow in upcoming releases. Performance was the other focus of this release. Variable-length traversals now use the edge label's index at each hop, whereas 2.17 scanned the entire label at every hop. On the public soc-Pokec graph (30 million edges), a two-hop traversal that did not finish within 20 seconds in our tests on 2.17 now completes in milliseconds. Highlights GQL clauses: LET, FOR, FILTER, NEXT, FINISH and INSERT, plus standalone ORDER BY, OFFSET and LIMIT clauses. Graph subqueries: CALL { }, OPTIONAL CALL, EXISTS { }, COUNT { }, COLLECT { } and VALUE { }, plus CALL ... YIELD to invoke PostgreSQL functions from Cypher. Based on PostgreSQL 18.6: asynchronous I/O, uuidv7(), virtual generated columns, OAuth authentication, B-tree skip scan and all PostgreSQL fixes through 18.6. Faster graph queries: variable-length traversals, pattern matching, label scans, EXISTS subqueries, path functions, sorting, grouping and counting of vertices and edges, ordering by vector distance, and the SET and DELETE clauses. Typed property columns: frequently queried properties can be stored as native typed columns and indexed like any other PostgreSQL column for faster filtering and sorting. Security: Cypher writes now enforce row-level security policies, and fixed-length patterns also enforce row-level security and privileges on labels they match without naming them. AI and Python agensgraph-python 2.1: a

## PG Observability Map 1.0.0 Released

DevFeed: [PG Observability Map 1.0.0 Released](<https://devfeed.tech/articles/pg-observability-map-1-0-0-released-122266.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pg-observability-map-100-released-3427/>)

Author: Meob PostgreSQL Tools

Published: 2026-11-07T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [observability](<https://devfeed.tech/topics/observability.md>), [Tool](<https://devfeed.tech/topics/tool.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [browser](<https://devfeed.tech/tags/browser.md>), [easy](<https://devfeed.tech/tags/easy.md>), [features](<https://devfeed.tech/tags/features.md>), [functions](<https://devfeed.tech/tags/functions.md>), [interactive](<https://devfeed.tech/tags/interactive.md>), [interface](<https://devfeed.tech/tags/interface.md>), [lightweight](<https://devfeed.tech/tags/lightweight.md>), [mapping](<https://devfeed.tech/tags/mapping.md>), [metrics](<https://devfeed.tech/tags/metrics.md>), [navigation](<https://devfeed.tech/tags/navigation.md>), [observability](<https://devfeed.tech/tags/observability.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>), [statistics](<https://devfeed.tech/tags/statistics.md>), [system](<https://devfeed.tech/tags/system.md>), [tool](<https://devfeed.tech/tags/tool.md>), [web](<https://devfeed.tech/tags/web.md>), [web-based](<https://devfeed.tech/tags/web-based.md>)

### AI overview

PG Observability Map 1.0.0 is a browser-based tool for exploring PostgreSQL observability. It interactively maps system views, functions, and statistics to their corresponding PostgreSQL architectural sections, with navigation across versions, including PG 19 support. The announcement describes it as lightweight and provides links to a live demo and source code, but the supplied excerpt does not detail how to use it.

### Source excerpt

We are pleased to announce the initial release (1.0.0) of PG Observability Map, a interactive web-based tool designed to visualize and explore PostgreSQL observability, metrics, and internal diagnostic views. Key Features & Highlights: Interactive visual mapping of PostgreSQL system views, functions, and statistics. Architectural contextualization: each item is mapped directly to its corresponding PostgreSQL architectural section. Easy navigation across PostgreSQL versions (including PG 19 support). Lightweight interface, accessible directly via web browser. Links & Resources: Live Interactive Demo: meob.github.io/pg-observability-map/ Source Code & Documentation: github.com/meob/pg-observability-map

## HeapDeck: an on-call monitor for PostgreSQL on iPhone and iPad

DevFeed: [HeapDeck: an on-call monitor for PostgreSQL on iPhone and iPad](<https://devfeed.tech/articles/heapdeck-an-on-call-monitor-for-postgresql-on-iphone-and-ipad-122265.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/heapdeck-an-on-call-monitor-for-postgresql-on-iphone-and-ipad-3436/>)

Published: 2026-11-07T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [database monitoring](<https://devfeed.tech/topics/database-monitoring.md>), [Monitoring & Alerting](<https://devfeed.tech/topics/monitoring-alerting.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>), [iphone](<https://devfeed.tech/topics/iphone.md>), [ssh](<https://devfeed.tech/topics/ssh.md>), [ipad](<https://devfeed.tech/topics/ipad.md>), [TLS (Transport Layer Security)](<https://devfeed.tech/topics/tls.md>)

Tags: [alerting](<https://devfeed.tech/tags/alerting.md>), [alerts](<https://devfeed.tech/tags/alerts.md>), [app-store](<https://devfeed.tech/tags/app-store.md>), [blocking](<https://devfeed.tech/tags/blocking.md>), [canada](<https://devfeed.tech/tags/canada.md>), [client](<https://devfeed.tech/tags/client.md>), [counts](<https://devfeed.tech/tags/counts.md>), [free](<https://devfeed.tech/tags/free.md>), [ipad](<https://devfeed.tech/tags/ipad.md>), [iphone](<https://devfeed.tech/tags/iphone.md>), [lag](<https://devfeed.tech/tags/lag.md>), [locks](<https://devfeed.tech/tags/locks.md>), [monitor](<https://devfeed.tech/tags/monitor.md>), [native](<https://devfeed.tech/tags/native.md>), [on-call](<https://devfeed.tech/tags/on-call.md>), [pg-stat-statements](<https://devfeed.tech/tags/pg-stat-statements.md>), [pinned](<https://devfeed.tech/tags/pinned.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [ssh](<https://devfeed.tech/tags/ssh.md>), [tls](<https://devfeed.tech/tags/tls.md>)

### AI overview

HeapDeck is a native iPhone and iPad monitor for PostgreSQL 13-19, designed to help on-call engineers inspect database health while the app is open. It presents a health verdict and ten tiles; its Locks screen builds a blocking tree from pg_blocking_pids() and shows how many sessions stopping the root blocker would free. Other views cover activity, transaction ID wraparound, dead tuples, replication lag and slots, and query statistics. Connections are direct or use an SSH tunnel, with TLS and pinned fingerprints; no vendor server sits between the phone and database. HeapDeck sends no alerts, so it complements existing alerting. Monitoring one server is free; a one-time HeapDeck Pro purchase adds more servers and actions including cancel, terminate, VACUUM, dropping a slot, and writes.

### Source excerpt

HeapDeck is a new native app for engineers on call for PostgreSQL 13 to 19, on the App Store for iPhone and iPad. It opens on one health verdict with ten tiles. The Locks screen draws the tree from pg_blocking_pids() with the root blocker on top and counts the sessions that stopping it would free. Other screens cover pg_stat_activity, transaction ID wraparound and dead tuples, replication lag and slots, and pg_stat_statements. The app uses a direct connection or an SSH tunnel, with TLS and pinned fingerprints. No vendor server sits between the phone and the database. It works while open and sends no alerts, so it goes next to your existing alerting. Monitoring one server is free. HeapDeck Pro is a one-time in-app purchase that adds more servers and the actions: cancel, terminate, VACUUM, dropping a slot and writes. https://heapdeck.app Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission. HeapDeck is an independent client and is not affiliated with, endorsed by, or sponsored by the PostgreSQL Community Association of Canada, PostgreSQL Global Development Group, PostgreSQL Project, PostgreSQL Core Team, or PostgreSQL Community.

## Brume: FK-safe pseudonymization for PostgreSQL test and debug copies

DevFeed: [Brume: FK-safe pseudonymization for PostgreSQL test and debug copies](<https://devfeed.tech/articles/brume-fk-safe-pseudonymization-for-postgresql-test-and-debug-copies-122264.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/brume-fk-safe-pseudonymization-for-postgresql-test-and-debug-copies-3434/>)

Published: 2026-11-07T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Developer Tools](<https://devfeed.tech/topics/developer-tools.md>), [database-consistency](<https://devfeed.tech/topics/database-consistency.md>)

Tags: [apache-2-0](<https://devfeed.tech/tags/apache-2-0.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [debug](<https://devfeed.tech/tags/debug.md>), [debugging](<https://devfeed.tech/tags/debugging.md>), [development](<https://devfeed.tech/tags/development.md>), [email](<https://devfeed.tech/tags/email.md>), [encryption](<https://devfeed.tech/tags/encryption.md>), [fake](<https://devfeed.tech/tags/fake.md>), [foreign-keys](<https://devfeed.tech/tags/foreign-keys.md>), [integrity](<https://devfeed.tech/tags/integrity.md>), [personal-data](<https://devfeed.tech/tags/personal-data.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [referential-integrity](<https://devfeed.tech/tags/referential-integrity.md>), [synthetic](<https://devfeed.tech/tags/synthetic.md>), [table](<https://devfeed.tech/tags/table.md>), [target](<https://devfeed.tech/tags/target.md>), [test](<https://devfeed.tech/tags/test.md>), [testing](<https://devfeed.tech/tags/testing.md>), [tool](<https://devfeed.tech/tags/tool.md>)

### AI overview

Brume 2.1 creates deterministic, pseudonymized PostgreSQL extracts for testing, debugging, or demos while preserving foreign-key integrity. It reads from the source and transforms data before writing a selected subset to a target database or SQL file. Column strategies include synthetic values, partial masking, hashing, nullification, format-preserving encryption for identifiers, and date shifting. Stable outputs use user-provided secrets; linked_columns keeps shared values consistent even without formal foreign keys. Row filters and configurable traversal of parent and child foreign keys produce smaller coherent extracts. A reviewable brume.yml configures table and column strategies, semantic types, and JSONB paths. The text says Brume supports PostgreSQL 12-18 and describes pseudonymization as one GDPR measure; it does not claim pseudonymization alone ensures compliance.

### Source excerpt

Brume 2.1, an open source (Apache 2.0) tool that creates deterministic, foreign-key-safe pseudonymized copies of PostgreSQL databases for testing, debugging and demos, is now available. Why Brume? Development teams often need realistic data to reproduce bugs, run tests or prepare demos, but copying production exposes real personal data. Classic masking scripts also tend to break referential integrity, which forces you to disable triggers, suspend constraints or repair broken joins by hand. Brume copies a targeted subset of a source database to a target database or to a .sql file, and transforms personal data on the fly, before anything is written. Foreign keys stay valid end-to-end on the target. Brume only reads from the source database. Key features Column-level strategies: FAKE for realistic synthetic values, MASK for partial reveals, HASH for one-way hashing, NULLIFY to drop sensitive data, FPE_ID / FPE_UUID for format-preserving encryption of identifiers, and DATE_SHIFT to move dates while keeping their distribution. Deterministic output: transformations are keyed by your own secrets. The same input with the same secret always gives the same output, across all releases of a major version, so test fixtures and debug sessions stay stable from one run to the next. Referential integrity: format-preserving encryption rewrites primary keys and the foreign keys pointing to them consistently. With linked_columns, a value shared between tables that have no formal foreign key (for example, an email in both users and audit_logs) gets the same pseudonym everywhere. Subsetting: define row-level filters on any table (created_at >= '2025-01-01', tenant_id = 42...). Brume follows foreign keys up to a configurable depth, towards parents and children, to produce a small, self-contained and coherent extract. Declarative configuration: a single brume.yml file describes the strategy for each table and column, with semantic types (EMAIL, PHONE, IBAN, ADDRESS...) and JSONB paths to t

## ReinDB: read-only performance monitoring for PostgreSQL, first database free

DevFeed: [ReinDB: read-only performance monitoring for PostgreSQL, first database free](<https://devfeed.tech/articles/reindb-read-only-performance-monitoring-for-postgresql-first-database-free-119626.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/reindb-read-only-performance-monitoring-for-postgresql-first-database-free-3432/>)

Published: 2026-11-05T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [database monitoring](<https://devfeed.tech/topics/database-monitoring.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [database](<https://devfeed.tech/tags/database.md>), [first](<https://devfeed.tech/tags/first.md>), [free](<https://devfeed.tech/tags/free.md>), [google-cloud](<https://devfeed.tech/tags/google-cloud.md>), [linux](<https://devfeed.tech/tags/linux.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [performance](<https://devfeed.tech/tags/performance.md>), [performance-monitoring](<https://devfeed.tech/tags/performance-monitoring.md>), [pg-stat-statements](<https://devfeed.tech/tags/pg-stat-statements.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [windows](<https://devfeed.tech/tags/windows.md>)

### AI overview

ReinDB monitors PostgreSQL performance by learning each database's and statement's hour-by-hour baseline from pg_stat_statements, then flagging deviations ranked by the extra database time they cost. Flags include supporting evidence such as plan history and a testable fix script with an undo for each step. It requires one read-only login and installs nothing in the database. It can run hosted, onsite on Linux or Windows, or in the customer's AWS or Google Cloud account; MySQL, SQL Server, and Oracle are also supported. The first database is free for one person with no time limit or card requirement.

### Source excerpt

Bandlei has released ReinDB, read-only performance monitoring for PostgreSQL, self-managed or on Amazon RDS and Aurora. ReinDB learns what normal looks like for each database and statement, hour by hour, using pg_stat_statements, and flags what drifts from it, ranked by the extra database time each change costs. Each flag shows the evidence, including plan history, and a fix script your DBA can test, with an undo for each step. ReinDB installs nothing in your database and needs one read-only login. It runs hosted, onsite on Linux or Windows, or in your own AWS or Google Cloud account. MySQL, SQL Server and Oracle are also supported. The first database is free for one person, with no time limit and no card. A free 109-page guide, Rein In Your Database, covers the tuning method behind it. More at reindb.com.

## Autobase 2.12 released

DevFeed: [Autobase 2.12 released](<https://devfeed.tech/articles/autobase-2-12-released-119624.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/autobase-212-released-3430/>)

Published: 2026-11-05T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [Production Engineering](<https://devfeed.tech/topics/production-engineering.md>), [infrastructure monitoring](<https://devfeed.tech/topics/infrastructure-monitoring.md>), [ClusterControl](<https://devfeed.tech/topics/clustercontrol.md>), [internal developer platform automation](<https://devfeed.tech/topics/internal-developer-platform-automation.md>), [CI/CD secrets management](<https://devfeed.tech/topics/ci-cd-secrets-management.md>), [Cloud Logging](<https://devfeed.tech/topics/cloud-logging.md>), [API Logging](<https://devfeed.tech/topics/api-logging.md>), [Amazon Elastic Block Store (Amazon EBS)](<https://devfeed.tech/topics/amazon-elastic-block-store-amazon-ebs.md>), [race-condition](<https://devfeed.tech/topics/race-condition.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-secrets-manager](<https://devfeed.tech/tags/aws-secrets-manager.md>), [azure](<https://devfeed.tech/tags/azure.md>), [backup](<https://devfeed.tech/tags/backup.md>), [built-in](<https://devfeed.tech/tags/built-in.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [environment-variables](<https://devfeed.tech/tags/environment-variables.md>), [files](<https://devfeed.tech/tags/files.md>), [gcp](<https://devfeed.tech/tags/gcp.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-clusters](<https://devfeed.tech/tags/postgresql-clusters.md>), [release](<https://devfeed.tech/tags/release.md>), [reliability](<https://devfeed.tech/tags/reliability.md>), [restore](<https://devfeed.tech/tags/restore.md>), [secrets-management](<https://devfeed.tech/tags/secrets-management.md>), [security](<https://devfeed.tech/tags/security.md>)

### AI overview

Autobase 2.12 adds Netdata-powered dashboards for system, PostgreSQL, PgBouncer, and table and index metrics, while keeping an existing monitoring system in place. AWS, GCP, and Azure cluster provisioning now distributes nodes across Availability Zones by default to reduce the impact of a single-zone failure. A new secrets role can export and store secrets in AWS Secrets Manager. The release also improves security through credential and secret redaction, secure password files, IMDSv2 enforcement, and EBS encryption with AWS KMS support. Reliability changes address WAL archiving and replica promotion during restores, and a new SSH jump-host option enables management of clusters on private networks without direct SSH access to database servers. The supplied excerpt is incomplete, so it does not establish the full set of release changes.

### Source excerpt

We are pleased to announce the release of Autobase 2.12! Highlights Built-in Monitoring Dashboards Autobase isn't intended to replace your monitoring system. Instead, we've integrated with Netdata, which we consider one of the best solutions for real-time infrastructure monitoring. Autobase Platform now includes built-in dashboards powered by the Netdata agent, providing convenient access to key metrics for: System -- CPU, memory, disk, and network performance PostgreSQL -- database health and performance PgBouncer -- connection pooling metrics Tables and Indexes -- statistics and performance insights Explore the dashboards in our live demo sandbox: https://demo.autobase.tech Multi-AZ Deployment When provisioning PostgreSQL clusters on AWS, GCP, and Azure, Autobase now distributes nodes across multiple Availability Zones (AZs) by default. This improves cluster resilience by reducing the impact of a single Availability Zone failure. Implementation details: AWS -- PR #1732 GCP -- PR #1738 Azure -- PR #1740 External Secrets Provider: AWS Secrets Manager We've introduced a new secrets role with support for AWS Secrets Manager. This integration enables Autobase to export and store secrets in AWS Secrets Manager, providing an option for centralized secrets management. Security Enhancements Autobase 2.12 includes important security improvements across the platform and automation engine: Redacted sensitive credentials and secrets from API request and service logs. Replaced PGPASSWORD environment variables with secure password files. Prevented sensitive pgBackRest configuration details from appearing in logs. Enforced IMDSv2 for AWS EC2 instances. Added EBS encryption and AWS KMS key support. Reliability Improvements This release also improves the safety and reliability of cluster management, backup, and restore operations: Preserved WAL archiving and prevented unintended replica promotion during restore operations. Fixed a race condition when creating pgBackRest stanzas on shared

## pgbadger v13.3 has been released

DevFeed: [pgbadger v13.3 has been released](<https://devfeed.tech/articles/pgbadger-v13-3-has-been-released-115763.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pgbadger-v133-has-been-released-3435/>)

Published: 2026-11-03T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [releases](<https://devfeed.tech/topics/releases.md>), [Tool](<https://devfeed.tech/topics/tool.md>), [patches](<https://devfeed.tech/topics/patches.md>)

Tags: [analyzer](<https://devfeed.tech/tags/analyzer.md>), [bugs](<https://devfeed.tech/tags/bugs.md>), [download](<https://devfeed.tech/tags/download.md>), [easy](<https://devfeed.tech/tags/easy.md>), [fast](<https://devfeed.tech/tags/fast.md>), [features](<https://devfeed.tech/tags/features.md>), [maintenance](<https://devfeed.tech/tags/maintenance.md>), [patches](<https://devfeed.tech/tags/patches.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-performance](<https://devfeed.tech/tags/postgresql-performance.md>), [professional-services](<https://devfeed.tech/tags/professional-services.md>), [project](<https://devfeed.tech/tags/project.md>), [queries](<https://devfeed.tech/tags/queries.md>), [release](<https://devfeed.tech/tags/release.md>), [reports](<https://devfeed.tech/tags/reports.md>), [speed](<https://devfeed.tech/tags/speed.md>), [sql](<https://devfeed.tech/tags/sql.md>), [support](<https://devfeed.tech/tags/support.md>), [traffic](<https://devfeed.tech/tags/traffic.md>)

### AI overview

pgBadger 13.3 is a maintenance release for PostgreSQL log analysis. It adds scrolling and mouseover support for graphs with more than 10 legend items and filters remote logs on the remote host in watch mode to avoid importing all logs. Fixes address --explode handling, multiline statements, incorrect query drops with --dbuser, and duplicate counting when the same execution appears in both log_min_duration_statement and auto_explain. It also adds explain-plan copying, handles "Query Parameters: ..." in auto_explain plans, and uses per-run temporary filenames to prevent concurrent pgBadger processes from reading the same files. The supplied text is an excerpt; the release notes are identified as the source for the complete change list.

### Source excerpt

Antananarivo, Madagascar - November 03, 2026 pgBadger pgBadger is a PostgreSQL performance analyzer, built for speed with fully detailed reports based on your PostgreSQL log files. pgBadger 13.3 was released today, this is a maintenance release that fixes issues and applied patches reported by users since last release. Add scroll on legend and mouseover graphs when the list of item is > 10. Fix several issues when the --explode option is used. Add filter of remote logs in watch mode on the remote host to not import all the log. Fix several issues with multiline statement in the log. Fix the same execution reported by both log_min_duration_statement and auto_explain resulting in counted twice. Add copy of explain plan. Handle "Query Parameters: ..." from auto_explain plan. Fix wrong queries dropped when filtering with --dbuser. Use per-run names for temporary dblist and last parsed files to prevent two pgbadger running at the same time to read the same files. For the complete list of changes, please checkout the release note on https://github.com/darold/pgbadger/releases Links & Credits I would like to thank all users who submitted patches and users who reported bugs and feature requests, they are all cited the ChangeLog file. pgBadger is an open project. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools or directly to pgbadger@darold.net. Links : Download: http://pgbadger.darold.net/ Support: use GitHub report tool at https://github.com/darold/pgbadger/issues or contact pgbadger@darold.net. For a complete list of commercial support near of your place take a look at the PostgreSQL Professional Services page, they all do great job and most of them can help you. About pgBadger : pgBagder is a new generation log analyzer for PostgreSQL, created by Gilles Darold (also author of ora2pg, the powerful migration tool). pgBadger is a fast and easy tool to analyze your SQL traffic and creat

## HypoPG 1.4.5 is out!

DevFeed: [HypoPG 1.4.5 is out!](<https://devfeed.tech/articles/hypopg-1-4-5-is-out-112943.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/hypopg-145-is-out-3428/>)

Author: Julien Rouhaud

Published: 2026-11-02T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [releases](<https://devfeed.tech/topics/releases.md>), [bugfixes](<https://devfeed.tech/topics/bugfixes.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [announce](<https://devfeed.tech/tags/announce.md>), [bug-fixes](<https://devfeed.tech/tags/bug-fixes.md>), [contribution](<https://devfeed.tech/tags/contribution.md>), [extension](<https://devfeed.tech/tags/extension.md>), [indexes](<https://devfeed.tech/tags/indexes.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [project](<https://devfeed.tech/tags/project.md>), [version](<https://devfeed.tech/tags/version.md>)

### AI overview

HypoPG 1.4.5 is a release of the PostgreSQL extension for hypothetical indexes, compatible with PostgreSQL 9.2 and later. It fixes a long-standing issue in `hypo_estimate_index` and relid handling in hypothetical indexes that could cause a crash. The supplied excerpt does not provide further release details.

### Source excerpt

Tainan, Taiwan - Sun 1 Nov 2026 HypoPG 1.4.5 I'm pleased to announce the release of the version 1.4.5 of HypoPG, an extension adding support for Hypothetical Indexes, compatible with PostgreSQL 9.2 and above. Changelog Bug fixes: Fix long standing thinko in hypo_estimate_index (Julien Rouhaud) Fix relid handling in hypothetical indexes, that could lead to a crash (Julien Rouhaud) Links & Credits Thank to the users who reported bugs, they are all cited in the CHANGELOG file. HypoPG is an open project. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the github repository at github.com/HypoPG/hypopg. Links Download: github.com/HypoPG/hypopg/releases Bug tracker: github.com/HypoPG/hypopg/issues

## Security release for psqlodbc

DevFeed: [Security release for psqlodbc](<https://devfeed.tech/articles/security-release-for-psqlodbc-112944.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/security-release-for-psqlodbc-3431/>)

Author: Postgresql ODBC

Published: 2026-11-02T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [Security](<https://devfeed.tech/topics/security.md>), [project release](<https://devfeed.tech/topics/project-release.md>)

Tags: [changelog](<https://devfeed.tech/tags/changelog.md>), [multiple](<https://devfeed.tech/tags/multiple.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>), [security](<https://devfeed.tech/tags/security.md>)

### AI overview

The PostgreSQL ODBC project released psqlodbc version 18.00.0006 to fix multiple security issues. The notice refers readers to the Changelog for details but does not identify the issues or describe the fixes.

### Source excerpt

The PostgreSQL ODBC project has released version 18.00.0006 to fix multiple security issues see the Changelog for details

## E-Maj 5.0.1 : Major Security Update.

DevFeed: [E-Maj 5.0.1 : Major Security Update.](<https://devfeed.tech/articles/e-maj-5-0-1-major-security-update-110070.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/e-maj-501-major-security-update-3425/>)

Author: Philippe Beaudoin

Published: 2026-10-31T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [Eloquent ORM](<https://devfeed.tech/topics/eloquent.md>)

Tags: [client](<https://devfeed.tech/tags/client.md>), [core](<https://devfeed.tech/tags/core.md>), [documentation](<https://devfeed.tech/tags/documentation.md>), [extension](<https://devfeed.tech/tags/extension.md>), [github](<https://devfeed.tech/tags/github.md>), [installation](<https://devfeed.tech/tags/installation.md>), [logging](<https://devfeed.tech/tags/logging.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [security](<https://devfeed.tech/tags/security.md>), [security-update](<https://devfeed.tech/tags/security-update.md>), [time](<https://devfeed.tech/tags/time.md>), [travel](<https://devfeed.tech/tags/travel.md>), [update](<https://devfeed.tech/tags/update.md>), [users](<https://devfeed.tech/tags/users.md>), [vulnerability](<https://devfeed.tech/tags/vulnerability.md>), [web](<https://devfeed.tech/tags/web.md>)

### AI overview

E-Maj 5.0.1 fixes a vulnerability present in all earlier versions that could let some users gain superuser privileges under certain circumstances; users are strongly encouraged to update promptly. E-Maj is a PostgreSQL extension for fine-grained write logging and time travel on database subsets. Version 5.0.1 supports Postgres 14-19. Emaj_web 5.0 is compatible with E-Maj extension versions 3.0-5.0.

### Source excerpt

We are very glad to announce the E-Maj 5.0.1 version. E-Maj is a PostgreSQL extension which enables fine-grained write logging and time travel on subsets of the database. This version mainly fixes a vulnerability encountered in all previous versions, allowing some users to gain superuser privileges under certain circumstances. Users are strongly encouraged to update their installed version as soon as possible. E-Maj 5.0.1 is compatible with Postgres 14 to 19 versions. Emaj_web 5.0 is compatible with emaj extension 3.0 to 5.0 versions. The full documentation is available on line. The core extension is available at pgxn.org for installation or github.org for development. The Emaj_web client is also available at github.org. Have fun with E-Maj !

## pgAdmin 4 v9.19 Released

DevFeed: [pgAdmin 4 v9.19 Released](<https://devfeed.tech/articles/pgadmin-4-v9-19-released-110071.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pgadmin-4-v919-released-3426/>)

Author: Pgadmin Development Team

Published: 2026-10-31T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [Tool](<https://devfeed.tech/topics/tool.md>), [free software](<https://devfeed.tech/topics/free-software.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [announce](<https://devfeed.tech/tags/announce.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [bug](<https://devfeed.tech/tags/bug.md>), [bug-fixes](<https://devfeed.tech/tags/bug-fixes.md>), [change](<https://devfeed.tech/tags/change.md>), [changes](<https://devfeed.tech/tags/changes.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [command-injection](<https://devfeed.tech/tags/command-injection.md>), [configure](<https://devfeed.tech/tags/configure.md>), [copy](<https://devfeed.tech/tags/copy.md>), [csv](<https://devfeed.tech/tags/csv.md>), [data](<https://devfeed.tech/tags/data.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [development](<https://devfeed.tech/tags/development.md>), [directory](<https://devfeed.tech/tags/directory.md>), [encoding](<https://devfeed.tech/tags/encoding.md>), [environment](<https://devfeed.tech/tags/environment.md>), [pgadmin](<https://devfeed.tech/tags/pgadmin.md>), [pgadmin-4](<https://devfeed.tech/tags/pgadmin-4.md>)

### AI overview

pgAdmin 4 v9.19 includes 136 bug fixes and new features, with fixes for 15 security vulnerabilities. Notable additions include extended statistics management, editing data through simple auto-updatable views, exporting Query Tool results as JSON or XML with encoding options, and managing pg_timetable chains and tasks. In server mode, free-text Password Exec Commands are replaced by the administrator-defined SERVER_PASSEXEC_COMMANDS allowlist; configure it before the first start after upgrading. Security fixes address command injection, authentication and login-check bypasses, exposure of users' credentials and files, and unsafe file-path handling. The release also fixes Schema Diff, View/Edit Data, Kerberos, encoding, and Linux packaging issues.

### Source excerpt

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.19. This release of pgAdmin 4 includes 136 bug fixes and new features, including fixes for 15 security vulnerabilities (CVE-2026-116238 through CVE-2026-116252). For more details please see the release notes. pgAdmin is the leading open-source graphical management tool for PostgreSQL. For more information, please see the website. Notable changes in this release include: Features Add a Statistics node for creating and managing extended statistics. Allow data to be edited through simple auto-updatable views in View/Edit Data. Save Query Tool results as JSON or XML as well as CSV, with a selectable encoding, an optional byte order mark, and a 'copy with headers' option. Add support for managing pg_timetable chains and tasks. Replace free-text Password Exec Commands in server mode with an administrator-defined allowlist, SERVER_PASSEXEC_COMMANDS; the commands run without a shell and with a reduced environment. Configure SERVER_PASSEXEC_COMMANDS before the first start after upgrading. Add pgEdge Starfleet to the Deploy Cloud Instance wizard. Allow the login page to be skipped when OAuth2 is the only authentication source. Security Fixes Fix OS command injection in the Import/Export Data tool, where a query-based export could smuggle a live TO PROGRAM clause past the \copy parenthesis guard through a backslash in a double-quoted identifier and run an arbitrary command on the pgAdmin host; an incomplete fix for CVE-2026-17566 (CVE-2026-116241). Fix LDAP and Kerberos authentication logging a user in to a different account that shared their username, including the initial administrator (CVE-2026-116239). Fix bypasses of the failed-login limit and of pgAdmin's own login, password-change and password-reset checks, through Flask-Security's own views and through username case and second-source handling (CVE-2026-116238). Fix connection file paths and parameter keys escaping the user's storage directory, whic

## PostgreSQL Anonymizer 3.3 : Major Security Update

DevFeed: [PostgreSQL Anonymizer 3.3 : Major Security Update](<https://devfeed.tech/articles/postgresql-anonymizer-3-3-major-security-update-105461.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/postgresql-anonymizer-33-major-security-update-3423/>)

Published: 2026-10-28T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [Security](<https://devfeed.tech/topics/security.md>), [pii](<https://devfeed.tech/topics/pii.md>), [sensitive data](<https://devfeed.tech/topics/sensitive-data.md>), [vulnerability management](<https://devfeed.tech/topics/vulnerability-management.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [critical](<https://devfeed.tech/tags/critical.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [dbaas](<https://devfeed.tech/tags/dbaas.md>), [debian](<https://devfeed.tech/tags/debian.md>), [docker](<https://devfeed.tech/tags/docker.md>), [extension](<https://devfeed.tech/tags/extension.md>), [masking](<https://devfeed.tech/tags/masking.md>), [personally-identifiable-information](<https://devfeed.tech/tags/personally-identifiable-information.md>), [pii](<https://devfeed.tech/tags/pii.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [security](<https://devfeed.tech/tags/security.md>), [security-fixes](<https://devfeed.tech/tags/security-fixes.md>), [security-update](<https://devfeed.tech/tags/security-update.md>), [sensitive-data](<https://devfeed.tech/tags/sensitive-data.md>), [sql](<https://devfeed.tech/tags/sql.md>), [strategies](<https://devfeed.tech/tags/strategies.md>), [update](<https://devfeed.tech/tags/update.md>)

### AI overview

PostgreSQL Anonymizer 3.3 fixes 12 critical vulnerabilities that could, in some circumstances, let users gain superuser privileges or masked users access personal information. The release adds restrictions against malicious behavior. The source urges all users to upgrade to 3.3 as soon as possible and strongly advises changing the `anon.salt` GUC parameter; it points to the UPGRADE section for details. The extension masks personally identifiable or commercially sensitive data using six strategies and functions such as substitution, pseudonymization, scrambling, and noise addition. The excerpt names package, Ansible, and Docker installation options and several DBaaS providers and PostgreSQL forks, but does not include the full vulnerability list or detailed upgrade instructions.

### Source excerpt

Eymoutiers, France, October 27th, 2026 Dalibo is pleased to announce PostgreSQL Anonymizer 3.3 with a panel of important security fixes. 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 strategies: Dynamic Masking - Real-time data protection Static Masking - Permanent data transformation Replica Masking - Anonymized logical replication Backup Masking - Privacy-protected database exports Masking Views - Controlled data visibility Masking Data Wrappers - Extended protection across systems Each strategy is complemented by an enhanced suite of Masking Functions, including advanced techniques such as: Substitution, Randomization, Faking, Pseudonymization, Partial Scrambling, Shuffling, Noise Addition and Generalization. The extension can be installed with Debian and RPM packages, an Ansible role, a Docker image, etc. You can use it on most major DBaaS providers including : Alibaba Cloud, Crunchy Bridge, Google Cloud SQL, IBM Cloud, Microsoft Azure Database, Neon, Yandex It is also available on some Postgres forks such as EDB Advanced Postgres, Greenplum and Yugabyte. See the INSTALL section of the documentation for more details! Important Security Update Version 3.3 includes fixes for 12 critical vulnerabilities allowing some users to gain superuser privileges under certain circumstances or allowing masked users to access personal information. These vulnerabilities are declared below: CVE-2026-110181: Masked roles read the authentic data through SQL functions with a SQL-standard body CVE-2026-105615: Masked roles can read pg_stats CVE-2026-105616: The secret salt is readable in pg_db_role_setting CVE-2026-110183: After the static masking, pg_stats keeps the authentic values of the masked columns CVE-2026-105619: Masking rules are not applied through security_invoker views CVE-20

## PostgreSQL@SCaLE24x CfP closing soon on Nov 1, 2027

DevFeed: [PostgreSQL@SCaLE24x CfP closing soon on Nov 1, 2027](<https://devfeed.tech/articles/postgresql-scale24x-cfp-closing-soon-on-nov-1-2027-105462.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/postgresqlscale24x-cfp-closing-soon-on-nov-1-2027-3363/>)

Author: SCaLE Conference

Published: 2026-10-28T00:00:00Z

Content type: news

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Developer Events](<https://devfeed.tech/topics/developer-events.md>), [Insight for DBAs](<https://devfeed.tech/topics/insight-for-dbas.md>), [developer-relations](<https://devfeed.tech/topics/developer-relations.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [advanced](<https://devfeed.tech/tags/advanced.md>), [ai](<https://devfeed.tech/tags/ai.md>), [backend](<https://devfeed.tech/tags/backend.md>), [cfp](<https://devfeed.tech/tags/cfp.md>), [cloud-native](<https://devfeed.tech/tags/cloud-native.md>), [community](<https://devfeed.tech/tags/community.md>), [community-engagement](<https://devfeed.tech/tags/community-engagement.md>), [contributors](<https://devfeed.tech/tags/contributors.md>), [database](<https://devfeed.tech/tags/database.md>), [deployments](<https://devfeed.tech/tags/deployments.md>), [developers](<https://devfeed.tech/tags/developers.md>), [educators](<https://devfeed.tech/tags/educators.md>), [full-stack](<https://devfeed.tech/tags/full-stack.md>), [home](<https://devfeed.tech/tags/home.md>), [internals](<https://devfeed.tech/tags/internals.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [modern](<https://devfeed.tech/tags/modern.md>), [operations](<https://devfeed.tech/tags/operations.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

PostgreSQL@SCaLE is a two-day event scheduled for April 1-2, 2027, at the Pasadena Convention Center as part of SCaLE 24x. Its program pairs a Thursday full-day training track with technical talks on topics including internals, performance, replication, reliability, tooling, AI, and cloud-native workloads, plus an AMA with contributors and experienced operators. It is aimed at people running PostgreSQL and practitioners across database administration, development, operations, and platform engineering. The call for papers is open through November 1, 2026; submissions should be tagged "PostgreSQL" for routing to the track committee.

### Source excerpt

Hi folks! We're hosting a PostgreSQL track at SCaLE again -- come join us in sunny Pasadena! PostgreSQL@SCaLE is a two-day event on Thursday-Friday, April 1-2, 2027, at the Pasadena Convention Center, part of SCaLE 24x (April 1-4). The program brings together PostgreSQL core contributors, long-time community leaders, and professionals running Postgres in production to share practical, experience-driven knowledge. Sessions cover how PostgreSQL works, how to operate it reliably at scale, and how to use it well in modern systems -- from foundational operations through advanced internals and large-scale deployments. Who it's for Database administrators (DBAs) Backend, web, and full-stack developers Sysadmins and site reliability engineers Platform, cloud-native, and Kubernetes practitioners Anyone running PostgreSQL in production or at home What to expect PostgreSQL training -- one Thursday track dedicated to full-day training led by experienced PostgreSQL educators and practitioners. Technical talks -- internals, performance, replication, reliability, tooling, and modern workloads including AI and cloud-native environments. Community engagement -- direct access to contributors and experienced operators, including an Ask Me Anything (AMA) session. Call for Papers The CfP is open through November 1, 2026. Tag your submission PostgreSQL so it's routed to the PostgreSQL@SCaLE committee.

## ReviveDB: Supabase backups restore-tested against the source schema

DevFeed: [ReviveDB: Supabase backups restore-tested against the source schema](<https://devfeed.tech/articles/revivedb-supabase-backups-restore-tested-against-the-source-schema-105463.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/revivedb-supabase-backups-restore-tested-against-the-source-schema-3422/>)

Published: 2026-10-28T00:00:00Z

Content type: article

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [Supabase](<https://devfeed.tech/topics/supabase.md>), [backups](<https://devfeed.tech/topics/backups.md>), [Disaster Recovery](<https://devfeed.tech/topics/disaster-recovery.md>), [database-consistency](<https://devfeed.tech/topics/database-consistency.md>)

Tags: [auth](<https://devfeed.tech/tags/auth.md>), [backups](<https://devfeed.tech/tags/backups.md>), [database](<https://devfeed.tech/tags/database.md>), [edge](<https://devfeed.tech/tags/edge.md>), [extensions](<https://devfeed.tech/tags/extensions.md>), [files](<https://devfeed.tech/tags/files.md>), [functions](<https://devfeed.tech/tags/functions.md>), [indexes](<https://devfeed.tech/tags/indexes.md>), [inventory](<https://devfeed.tech/tags/inventory.md>), [policies](<https://devfeed.tech/tags/policies.md>), [policy](<https://devfeed.tech/tags/policy.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [project](<https://devfeed.tech/tags/project.md>), [recovery](<https://devfeed.tech/tags/recovery.md>), [restore](<https://devfeed.tech/tags/restore.md>), [row-level-security](<https://devfeed.tech/tags/row-level-security.md>), [schema](<https://devfeed.tech/tags/schema.md>), [supabase](<https://devfeed.tech/tags/supabase.md>), [supabase-backups](<https://devfeed.tech/tags/supabase-backups.md>)

### AI overview

ReviveDB backs up Supabase projects on Postgres 17 outside Supabase and verifies each database backup by restoring it to a temporary PostgreSQL database, then comparing its schema and objects with a source inventory. Checks include tables, row counts, columns, constraints, indexes, sequences, views, functions, triggers, RLS policies, grants and extensions, since matching row counts alone can miss lost constraints or policies. Each run uses a short-lived, read-only Postgres role that can also read rows protected by row-level security. A recovery point includes Auth data, Storage files and Edge Functions, and can be restored to a new Supabase project or to the original after rehearsal on a copy.

### Source excerpt

ReviveDB backs up Supabase projects on Postgres 17 outside Supabase, and restores every database backup into a temporary PostgreSQL database before it counts as verified. The restore is compared with an inventory of the source: tables, rows, columns, constraints, indexes, sequences, views, functions, triggers, RLS policies, grants and extensions. Row counts alone miss a restore that loses a constraint or a policy. Each backup run uses its own short-lived, read-only Postgres role that also reads rows behind row-level security. The same recovery point holds Auth data, Storage files and Edge Functions. A recovery point restores into a new Supabase project, or into the original after a rehearsal on a copy. Free for one project: https://revivedb.dev

## Estuary Expands PostgreSQL CDC with Targeted Backfills and Scalable Discovery

DevFeed: [Estuary Expands PostgreSQL CDC with Targeted Backfills and Scalable Discovery](<https://devfeed.tech/articles/estuary-expands-postgresql-cdc-with-targeted-backfills-and-scalable-discovery-105459.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/estuary-expands-postgresql-cdc-with-targeted-backfills-and-scalable-discovery-3419/>)

Published: 2026-10-28T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [neki](<https://devfeed.tech/topics/neki.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [schema-evolution](<https://devfeed.tech/topics/schema-evolution.md>)

Tags: [cdc](<https://devfeed.tech/tags/cdc.md>), [change-data-capture](<https://devfeed.tech/tags/change-data-capture.md>), [change-detection](<https://devfeed.tech/tags/change-detection.md>), [discovery](<https://devfeed.tech/tags/discovery.md>), [estuary](<https://devfeed.tech/tags/estuary.md>), [filter](<https://devfeed.tech/tags/filter.md>), [improve-reliability](<https://devfeed.tech/tags/improve-reliability.md>), [pipeline](<https://devfeed.tech/tags/pipeline.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [queries](<https://devfeed.tech/tags/queries.md>), [recovery](<https://devfeed.tech/tags/recovery.md>), [replication](<https://devfeed.tech/tags/replication.md>)

### AI overview

Estuary's PostgreSQL CDC updates add controls for recovery and large-schema discovery. An Additional Backfill Filter applies a SQL expression to one table's backfill queries, which can limit rows reread; it does not affect ongoing CDC, and changing it requires another backfill. Discovery filters can include selected schemas, exclude schemas, use glob-based table patterns, and optionally find tables outside the PostgreSQL publication. Metadata discovery runs in smaller groups for improved reliability. Active captures can also set their rediscovery interval (15 minutes by default) to tune the tradeoff between detecting new tables or schema changes sooner and catalog-query activity. The connector uses PostgreSQL logical replication and supports PostgreSQL 10.0 and later, including self-hosted and managed services.

### Source excerpt

Estuary has released several updates to its PostgreSQL change data capture (CDC) connector focused on backfill recovery, discovery at scale, and schema-change detection. Targeted Backfills PostgreSQL capture bindings now support an Additional Backfill Filter, allowing a SQL expression to be applied to backfill queries for an individual table. This can reduce the amount of data that needs to be re-read when only a subset of a large PostgreSQL table needs to be recovered or re-backfilled. For example, teams can use an indexed identifier or timestamp to limit the rows included in a recovery backfill. The filter affects backfills only. Ongoing PostgreSQL CDC continues to capture new changes independently of the filter. Because the SQL expression is applied directly to backfill queries, this is an advanced option and should be configured carefully. Changing the filter requires the affected binding to be backfilled again. Discovery Controls for Large PostgreSQL Schemas Estuary has also added PostgreSQL discovery filters that allow captures to control which tables are surfaced during connector discovery. Captures can now: include only selected PostgreSQL schemas exclude selected schemas discover tables using glob-based table patterns optionally discover tables that are not yet included in the PostgreSQL publication These controls are useful for PostgreSQL environments with large numbers of schemas or tables where only part of the database should participate in a CDC pipeline. Table metadata discovery is also processed in smaller groups to improve reliability when working with databases containing large numbers of tables. Configurable Rediscovery PostgreSQL captures can now configure how frequently Estuary re-runs discovery while a capture is active. Rediscovery is used to detect changes such as newly added tables and schema updates. The default interval is 15 minutes and can be adjusted for environments that require faster or less frequent discovery. This gives PostgreSQL

[Next page](<https://devfeed.tech/sources/postgresql-news.md?cursor=WyIyMDI2LTEwLTI4VDAwOjAwOjAwKzAwOjAwIiwgIjQxOTcxYmI0LWEyMWQtNDljNC04NGYzLWE0NWZlZjY3NGMxNiJd>)