# 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.

## pgAdmin 4 v9.18 Released

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

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

Author: Pgadmin Development Team

Published: 2026-09-17T00: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>), [Security](<https://devfeed.tech/topics/security.md>), [Vulnerabilities](<https://devfeed.tech/topics/vulnerabilities.md>), [Authentication](<https://devfeed.tech/topics/authentication.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [GUI](<https://devfeed.tech/topics/gui.md>), [vs-code](<https://devfeed.tech/topics/vs-code.md>), [React](<https://devfeed.tech/topics/react.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [announce](<https://devfeed.tech/tags/announce.md>), [authentication-bypass](<https://devfeed.tech/tags/authentication-bypass.md>), [bug-fixes](<https://devfeed.tech/tags/bug-fixes.md>), [cve](<https://devfeed.tech/tags/cve.md>), [database](<https://devfeed.tech/tags/database.md>), [react](<https://devfeed.tech/tags/react.md>), [security](<https://devfeed.tech/tags/security.md>), [security-vulnerabilities](<https://devfeed.tech/tags/security-vulnerabilities.md>), [vs-code](<https://devfeed.tech/tags/vs-code.md>)

### AI overview

The pgAdmin Development Team announces pgAdmin 4 version 9.18, a release containing 29 bug fixes and new features, including fixes for four security vulnerabilities. Changes include Object Explorer improvements, a hardened Content-Security-Policy, and fixes for authentication bypass and connection-string or argument injection issues in database-management tools.

### Source excerpt

The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.18. This release of pgAdmin 4 includes 29 bug fixes and new features, including fixes for four security vulnerabilities (CVE-2026-86861 through CVE-2026-86864). 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 Collapse and restore the Object Explorer by re-clicking the current workspace icon, in the manner of the VS Code side bar, remembering the choice across refreshes. A keyboard shortcut, Ctrl+Alt+B by default, does the same thing and can be changed through the new toggle_object_explorer preference. Harden the default Content-Security-Policy so inline scripts run under a per-request nonce rather than a blanket 'unsafe-inline', and drop 'unsafe-eval'. style-src keeps 'unsafe-inline', because MUI and React inject runtime styles and inline style attributes that cannot carry a nonce, and development bundles have 'unsafe-eval' re-added automatically when DEBUG is set. Security Fixes Fix an authentication bypass in Webserver authentication mode, where get_user() fell back to reading the configured WEBSERVER_REMOTE_USER name from the inbound request headers when it was absent from the WSGI environment. Because a header is written by whoever sends the request, any client that could reach pgAdmin could assert any identity, including an administrator's, without presenting a credential. A header-asserted identity is now opt-in, restricted to a configured list of trusted proxies with an optional shared secret, and refused for accounts whose authentication source is not webserver (CVE-2026-86863). Fix argument and connection-string injection in the Backup tool, where the client-supplied database name was appended to the pg_dump argument vector as a bare positional value. Because getopt_long permutes arguments, a value beg

## pgAssistant 3.8.0 : continuous improvement loop for Postgres

DevFeed: [pgAssistant 3.8.0 : continuous improvement loop for Postgres](<https://devfeed.tech/articles/pgassistant-3-8-0-continuous-improvement-loop-for-postgres-30889.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pgassistant-380-continuous-improvement-loop-for-postgres-3378/>)

Author: Pgassistant Dev Team

Published: 2026-09-16T00: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>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [recommendations](<https://devfeed.tech/topics/recommendations.md>), [configuration](<https://devfeed.tech/topics/configuration.md>), [real-time](<https://devfeed.tech/topics/real-time.md>)

Tags: [configuration](<https://devfeed.tech/tags/configuration.md>), [measurements](<https://devfeed.tech/tags/measurements.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [recommendations](<https://devfeed.tech/tags/recommendations.md>), [release](<https://devfeed.tech/tags/release.md>)

### AI overview

pgAssistant 3.8.0 expands the PostgreSQL analysis and tuning tool into a continuous improvement platform. It adds historical workload and environment measurements, compares consecutive collections, tracks recommendations and configuration changes, and helps teams measure changes while distinguishing correlation from causation.

### Source excerpt

With this release, pgAssistant is evolving beyond PostgreSQL analysis and tuning to become a continuous PostgreSQL improvement platform. The new positioning is built around a continuous improvement loop: Observe -> Diagnose -> Prioritize -> Plan -> Implement -> Collect again -> Measure pgAssistant already helped identify what should be improved and turn recommendations into a prioritized Executive Plan with clear DEV and OPS ownership. Combined with pgAssistant Collector, version 3.8.0 goes further by adding historical workload and environment measurements. The objective is to answer four essential questions: What should we improve? What did we decide to do? What did we actually change? What was the result? Workload Insights compares consecutive collections and highlights: new and no-longer-detected recommendations; changes to the PostgreSQL version and configuration; workload evolution by statement type; changes in execution time and call volume; the queries with the greatest impact on the overall workload. The ambition is to correlate the application of pgAssistant recommendations and the Executive Plan with observed performance changes. Correlation is not causation, and a recommendation that is no longer detected does not necessarily prove that it was implemented. pgAssistant keeps these distinctions explicit while bringing the relevant evidence together in one place. pgAssistant is not intended to replace real-time monitoring. Monitoring shows what is happening now; pgAssistant helps teams decide what to improve next, organize the remediation work, and measure what changed afterwards. From recommendations to action--and from action to measurable evidence. pgAssistant 3.8.0: https://github.com/beh74/pgassistant-community pgAssistant Collector: https://github.com/beh74/pgassistant-collector pgAssistant Grafana : https://github.com/beh74/pgassistant-grafana

## CERN PGDay 2027: Announcement and CfP

DevFeed: [CERN PGDay 2027: Announcement and CfP](<https://devfeed.tech/articles/cern-pgday-2027-announcement-and-cfp-4715.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/cern-pgday-2027-announcement-and-cfp-3375/>)

Author: Swiss PostgreSQL Users Group

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

Content type: news

Language: en

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

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Machine learning](<https://devfeed.tech/topics/machine-learning.md>), [AI search](<https://devfeed.tech/topics/ai-search.md>), [Retrieval Augmented Generation (RAG)](<https://devfeed.tech/topics/retrieval-augmented-generation-rag.md>)

Tags: [announcement](<https://devfeed.tech/tags/announcement.md>), [community](<https://devfeed.tech/tags/community.md>), [conference](<https://devfeed.tech/tags/conference.md>), [database](<https://devfeed.tech/tags/database.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

CERN PGDay 2027 is an announcement and call for papers for a single-day PostgreSQL community conference at CERN in Geneva. Proposed talk themes include large-scale database performance, AI and vector-search workloads, security, and PostgreSQL extensibility.

### Source excerpt

CERN PGDay 2027 Date: Friday, February 12, 2027 Location: CERN Campus, Geneva, Switzerland / Suisse Romande Language: English Organizers: Swiss PostgreSQL Users Group (SwissPUG) & CERN Format: Single-track (6-7 sessions) followed by networking social event Homepage: swisspug.org/cern-pgday-2027 About the Event Continuing in the line of work of the past editions, CERN PGDay 2027 returns as the annual gathering for PostgreSQL users, developers, and enthusiasts across Suisse Romande (western Switzerland) and the neighboring French border regions. Co-organized by CERN and SwissPUG, this single-day community conference offers a premier opportunity to network, share practical experiences, and explore the future of the world's most advanced open-source database. The event takes place in the unique, international environment of Geneva--a hub for major scientific institutions, non-governmental organizations, and financial and tech enterprises. Format & Venue Single-Track Schedule: The program consists of a single track featuring 6 to 7 technical sessions presented entirely in English. Social Event & Networking: Following the technical presentations, a social event will take place to facilitate community networking, discussions, and collaboration in the inspiring atmosphere of CERN. CERN Visits: Attendees are encouraged to arrange their schedules before or after the event to take advantage of the conference location and visit CERN, the European Organization for Nuclear Research. Call for Papers (CfP) Speaker proposals for CERN PGDay 2027 can be entered online via Indico. Call for Papers Closes: November 8, 2026 (23:59 CET) Call for Sponsors (CfS) Sponsors proposals for CERN PGDay 2027 are welcome. Please find the contract with all details online. Key Themes We welcome talk proposals covering broader PostgreSQL and community trends and localized enterprise & scientific topics: High-Performance Science & Big Data: Managing massive datasets, extreme write throughput, partitioning

## PostgreSQL Migrator 1.0 : first stable release

DevFeed: [PostgreSQL Migrator 1.0 : first stable release](<https://devfeed.tech/articles/postgresql-migrator-1-0-first-stable-release-4722.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/postgresql-migrator-10-first-stable-release-3377/>)

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

Content type: release

Language: en

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

Topics: [migration](<https://devfeed.tech/topics/migration.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [releases](<https://devfeed.tech/topics/releases.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>), [ci](<https://devfeed.tech/topics/ci.md>)

Tags: [ci](<https://devfeed.tech/tags/ci.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>)

### AI overview

PostgreSQL Migrator 1.0 is the first stable release of an open-source tool for migrating Oracle, MySQL, and MariaDB databases to PostgreSQL. It supports full inspection and limited conversion and migration for selected database objects, with compatibility promised across 1.x releases.

### Source excerpt

Paris, 7th september 2026. The Dalibo team is pleased to announce the release of PostgreSQL Migrator 1.0 stable, a free and open-source tool designed to help migrate databases from Oracle and MySQL/MariaDB to PostgreSQL. Key features Easy installation: pure Go binary with zero proprietary dependencies. Fast, offline inspection: Extract the full source catalog once, then iterate on conversion offline. Complexity scoring: Quickly assess and compare the difficulty of migration projects. Interactive web UI: Browse both the original and converted catalogs, search objects, and identify migration blockers. Schema and data conversion: Converts datatype and SQL expression, convert column to boolean. Code analysis and transpilation: Transpiles and analyzes SQL, PL/SQL and routines with the companion transqlate tool. High-performance data copy: Streamed bulk COPY to PostgreSQL (or to files / pipes), with low memory usage and significantly higher throughput than traditional tools in our tests. Hackable & configurable: Reliable JSON catalog data, TOML configuration, and templating for fine-tuning. Supported features PostgreSQL Migrator supports migrating from Oracle Database 11g to 26ai, MySQL 8.4+ and MariaDB 10+ to PostgreSQL 16 up to 19. Version 1.0 has full inspection including jobs, system triggers, etc. However, conversion and migration is limited to role, schema, sequences, table, virtual columns, constraints and indexes. The documentation describes implemented and planned features including views, procedural objects, SQL Server and more. Stability We have built a demanding CI pipeline including end-to-end tests based on Oracle Free container and cypress. This effectively prevents regression and ensure quality. After one year of beta and rc, PostgreSQL Migrator is stable. We'll ensure configuration, CLI and project compatibility for all 1.x releases. License and availability PostgreSQL Migrator is released under the PostgreSQL License. Documentation: https://postgresql-mi

## pg\_vault\_tde v1.7.1 : Transparent Data Encryption for PostgreSQL 17 and 18

DevFeed: [pg\_vault\_tde v1.7.1 : Transparent Data Encryption for PostgreSQL 17 and 18](<https://devfeed.tech/articles/pg-vault-tde-v1-7-1-transparent-data-encryption-for-postgresql-17-and-18-4719.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pg_vault_tde-v171-transparent-data-encryption-for-postgresql-17-and-18-3376/>)

Author: Miriade Srl

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

Content type: release

Language: en

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

Topics: [Encryption](<https://devfeed.tech/topics/encryption.md>), [Database](<https://devfeed.tech/topics/database.md>), [Cryptography](<https://devfeed.tech/topics/cryptography.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [encryption](<https://devfeed.tech/tags/encryption.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>)

### AI overview

pg_vault_tde 1.7.1 adds transparent AES-256-GCM encryption for PostgreSQL 17 and 18, with externally managed keys and online per-table key rotation. It fixes AAD derivation for out-of-line TOAST values; data written by 1.7.0 or earlier must be exported before upgrading affected tables.

### Source excerpt

pg_vault_tde provides Transparent Data Encryption for PostgreSQL 17 and 18. A table access method, encrypted_heap, encrypts every tuple with AES-256-GCM before it reaches the storage manager and decrypts it after it leaves, so applications require no changes. Keys are held outside the database: HashiCorp Vault or OpenBao through the Transit engine, a PKCS#11 token or HSM, or a local PKCS#12 wallet. Data encryption keys are per table and can be rotated online. Requirements are PostgreSQL 17 or 18, OpenSSL 3.x, and the library listed in shared_preload_libraries. The current release is 1.7.1. It corrects the AAD derivation for out-of-line TOAST values, with the consequence that TOAST data written by 1.7.0 or earlier does not authenticate under 1.7.1: affected tables must be exported before the new binary is installed. The procedure is documented in the README. pg_vault_tde is released under the PostgreSQL licence. Sources, documentation and binary .deb and .rpm packages are on GitHub; the distribution is on PGXN.

## PostgreSQL Anonymizer 3.2 : Faster Pseudonymization

DevFeed: [PostgreSQL Anonymizer 3.2 : Faster Pseudonymization](<https://devfeed.tech/articles/postgresql-anonymizer-3-2-faster-pseudonymization-4721.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/postgresql-anonymizer-32-faster-pseudonymization-3373/>)

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

Content type: release

Language: en

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

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Extension](<https://devfeed.tech/topics/extension.md>), [Vulnerabilities](<https://devfeed.tech/topics/vulnerabilities.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [extension](<https://devfeed.tech/tags/extension.md>), [pii](<https://devfeed.tech/tags/pii.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [privacy](<https://devfeed.tech/tags/privacy.md>), [security](<https://devfeed.tech/tags/security.md>), [vulnerabilities](<https://devfeed.tech/tags/vulnerabilities.md>)

### AI overview

PostgreSQL Anonymizer 3.2 adds faster localized pseudonymization functions, deprecates the previous pseudo_* functions, and fixes three critical privilege-escalation vulnerabilities.

### Source excerpt

Eymoutiers, France, Septembre 4th, 2026 Dalibo is pleased to announce PostgreSQL Anonymizer 3.2 introducing a new panel of fast pseudonymization filters. Enhanced Privacy Protection for Your Data PostgreSQL Anonymizer is an extension that hides or replaces personally identifiable information (PII) or commercially sensitive data from a PostgreSQL database. The extension offers 6 different masking 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! Fast and Localized pseudonymization Although Pseudonymization is not Anonymization, it may be useful in some contexts. Until version 3.1, this was achieved with a panel of pseudo_* functions, such as anon.pseudo_last_name(...), anon.pseudo_email(...), etc. These functions are now replaced by a new panel of anon.seeded_* functions, such as anon.seeded_last_name(...), anon.seeded_email(...), etc. The anon.seeded_* functions have 2 main advantages over the previous ones: They can be localized, e.g anon.seeded_street_name(id,'fr_FR') They are 40x faster :) The anon.pseudo_* functions are kept for backward compatibility but are now deprecated

## Autobase 2.11 released

DevFeed: [Autobase 2.11 released](<https://devfeed.tech/articles/autobase-2-11-released-4714.md>)

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

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

Content type: release

Language: en

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

Topics: [postgresql clusters](<https://devfeed.tech/topics/postgresql-clusters.md>), [Database](<https://devfeed.tech/topics/database.md>), [releases](<https://devfeed.tech/topics/releases.md>), [Ansible Roles](<https://devfeed.tech/topics/ansible-role.md>), [cloud-infrastructure](<https://devfeed.tech/topics/cloud-infrastructure.md>)

Tags: [ansible](<https://devfeed.tech/tags/ansible.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [operations](<https://devfeed.tech/tags/operations.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-clusters](<https://devfeed.tech/tags/postgresql-clusters.md>), [release](<https://devfeed.tech/tags/release.md>)

### AI overview

Autobase 2.11 adds Platform UI management for PostgreSQL cluster scaling, minor and major upgrades, backups, and point-in-time recovery. It also introduces Ansible playbooks for backup and recovery operations.

### Source excerpt

Autobase 2.11 is an important milestone in the evolution of the platform. Two years ago, we started working on a broader goal: evolve the Autobase Console from a PostgreSQL deployment UI into a platform for managing the complete cluster lifecycle. With this release, the remaining major pieces of that roadmap are now in place - scaling, upgrades, backups, and point-in-time recovery can all be managed directly from the Platform UI. See the full details in the release notes. Highlights Scaling (read replicas) Scale PostgreSQL read capacity directly from the UI. Simply specify the desired number of cluster nodes, and Autobase will provision the additional replicas automatically using the existing cloud configuration. For cloud deployments, the required servers and related infrastructure resources are created automatically. You can also scale clusters running on your own bare-metal or virtual machines. Start with a single-node PostgreSQL cluster and add replicas later as your workload grows. Upgrades Autobase Platform now supports minor upgrades within the current PostgreSQL major version as well as major-version upgrade workflows. For minor upgrades, replicas are updated one at a time, followed by a switchover and upgrade of the former primary. Read traffic remains available throughout the process, while expected write downtime is only ~5-10 seconds. For in-place major upgrades, the expected downtime is typically ~30-60 seconds. A blue-green major upgrade workflow with near-zero downtime is planned for a future release. Backup & Restore (PITR) Backup and recovery management is now available directly in the Platform UI. Configure the backup method, storage, retention, and schedule, or create backups on demand. Restore options include: Latest: recover to the latest available state Point in time: restore to a specific date and time Specific backup: restore from a selected backup New Ansible playbooks Autobase 2.11 adds new Ansible playbooks for backup and recovery operatio

## PGConf India 2027 - Dates Announced and CFP Open

DevFeed: [PGConf India 2027 - Dates Announced and CFP Open](<https://devfeed.tech/articles/pgconf-india-2027-dates-announced-and-cfp-open-4720.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pgconf-india-2027-dates-announced-and-cfp-open-3370/>)

Author: PGConf India

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

Content type: news

Language: en

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

Topics: [data](<https://devfeed.tech/topics/data.md>), [Replication](<https://devfeed.tech/topics/replication.md>)

Tags: [cloud](<https://devfeed.tech/tags/cloud.md>), [community](<https://devfeed.tech/tags/community.md>), [conference](<https://devfeed.tech/tags/conference.md>), [data](<https://devfeed.tech/tags/data.md>), [data-platforms](<https://devfeed.tech/tags/data-platforms.md>), [disaster-recovery](<https://devfeed.tech/tags/disaster-recovery.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [security](<https://devfeed.tech/tags/security.md>)

### AI overview

PGConf India 2027 will take place in Bengaluru from March 2-5, 2027. Its Call for Papers is open, with submissions due October 15, 2026, covering PostgreSQL topics including internals, performance, replication, cloud infrastructure, security, monitoring, production case studies, data platforms, extensions, and open source.

### Source excerpt

Hey there, Mark your calendars: PGConf India 2027 is set for March 2-5, 2027 at the Sheraton Grand Hotel at Brigade Gateway, Bengaluru. The Call for Papers is open right now. Important dates CFP closes -- October 15, 2026 We tell you yes/no -- November 15, 2026 The actual conference -- March 2-5, 2027 What we're into Basically anything Postgres, including but not limited to: Core internals & features Performance & query tuning HA, replication & disaster recovery Cloud & infra Security & compliance Monitoring & ops Real production case studies ML, analytics & data platforms (pgvector fans, this means you) Extensions & ecosystem tools Community & open source To submit Give us a title, session length (25 or 40 min), your bio, and an abstract (≤500 words) on what you'll say and what people should walk away with. Submit your talk Ticket sales aren't open yet -- watch pgconf.in for that and everything else. See you in Bengaluru. The PGConf India Team https://pgconf.in Powered By ConfBase.io

## pg\_statviz 1.2 released with PostgreSQL 19 support and new features

DevFeed: [pg\_statviz 1.2 released with PostgreSQL 19 support and new features](<https://devfeed.tech/articles/pg-statviz-1-2-released-with-postgresql-19-support-and-new-features-4718.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pg_statviz-12-released-with-postgresql-19-support-and-new-features-3369/>)

Author: Pg Statviz Project

Published: 2026-08-25T00: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>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Time Series](<https://devfeed.tech/topics/time-series.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>), [API](<https://devfeed.tech/topics/api.md>), [OpenAI](<https://devfeed.tech/topics/openai.md>), [Claude](<https://devfeed.tech/topics/claude.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-models](<https://devfeed.tech/tags/ai-models.md>), [api](<https://devfeed.tech/tags/api.md>), [claude](<https://devfeed.tech/tags/claude.md>), [features](<https://devfeed.tech/tags/features.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [openai](<https://devfeed.tech/tags/openai.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>), [series](<https://devfeed.tech/tags/series.md>)

### AI overview

pg_statviz 1.2 adds PostgreSQL 19 support, a blocking-locks analysis module, OpenAI API integration, and updated default Claude and Gemini models. It remains a lightweight PostgreSQL extension and utility for analyzing and visualizing internal statistics, with optional AI features.

### Source excerpt

Just in time for the PostgreSQL 19 betas, I'm excited to announce release 1.2 of pg_statviz, the minimalist extension and utility pair for time series analysis and visualization of PostgreSQL internal statistics. This release adds support for the upcoming PostgreSQL 19: pg_statviz now captures the new wal_fpi_bytes counter from pg_stat_wal. The PG18/19 I/O worker, effective WAL level, and autovacuum scoring settings are captured in snapshot_conf. The release has been tested against 19 beta3, and across the whole PostgreSQL 13 to 19 range. It also introduces a new blocking locks analysis module: Each snapshot now records the number of blocked and blocking sessions, along with a breakdown by lock type (relation, transactionid, tuple, and so on). Detection is built on pg_blocking_pids(), so even soft blocks (sessions that are just ahead in the lock wait queue) are counted, not just hard conflicts. Storage stays lightweight: table size is independent of how many sessions were involved in the blocking. The module produces charts and AI verdicts like every other module, and the deterministic severity floor applies here too: sustained blocking can never be reported as healthy. Also new is the openai AI provider: --ai openai uses the OpenAI API, so the same flag works with OpenAI itself and with any other service or local server that implements that API. You can select the endpoint and model with the OPENAI_BASE_URL and OPENAI_MODEL environment variables. The openai package has been added to the [ai] extras, and zero-dependency installs remain unchanged. Finally, this release also updates the default AI models to claude-sonnet-5 for Claude and gemini-3.7-flash for Gemini. pg_statviz takes the view that everything should be light and minimal. Unlike commercial monitoring platforms, it doesn't require invasive agents or open connections to the database: it all lives inside your database. The extension is plain SQL and PL/pgSQL and doesn't require modules to be loaded, the vis

## LibreDB Studio: an open source, self-hosted SQL IDE for PostgreSQL in the browser

DevFeed: [LibreDB Studio: an open source, self-hosted SQL IDE for PostgreSQL in the browser](<https://devfeed.tech/articles/libredb-studio-an-open-source-self-hosted-sql-ide-for-postgresql-in-the-browser-4716.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/libredb-studio-an-open-source-self-hosted-sql-ide-for-postgresql-in-the-browser-3368/>)

Published: 2026-08-20T00:00:00Z

Content type: article

Language: en

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

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [ide](<https://devfeed.tech/topics/ide.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [browser](<https://devfeed.tech/topics/browser.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [API](<https://devfeed.tech/topics/api.md>), [Authentication](<https://devfeed.tech/topics/authentication.md>), [OpenID connect (OIDC)](<https://devfeed.tech/topics/oidc.md>), [Authorization](<https://devfeed.tech/topics/authorization.md>), [Back end](<https://devfeed.tech/topics/backend.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [backend](<https://devfeed.tech/tags/backend.md>), [browser](<https://devfeed.tech/tags/browser.md>), [ide](<https://devfeed.tech/tags/ide.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>), [self-hosted](<https://devfeed.tech/tags/self-hosted.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

LibreDB Studio is an MIT-licensed, self-hosted SQL IDE for PostgreSQL that runs in the browser and can be deployed as a container, Helm chart, or npm package. The article describes its database-aware query editing, transaction controls, schema introspection, monitoring, optional query assistant, and local-account or OIDC authentication with role-based access control. Release 0.12.0 is highlighted.

### Source excerpt

LibreDB Studio is an MIT-licensed, self-hosted SQL IDE for PostgreSQL that runs in the browser and deploys as a container or Helm chart. It is deployed next to the database it manages, as a container, a Helm chart or an npm package, rather than installed on each developer's machine. PostgreSQL is its reference implementation: the provider is built on node-postgres, and the other supported engines follow the patterns established there. On a PostgreSQL connection the editor uses pooled connections, explicit BEGIN/COMMIT/ROLLBACK transactions with an auto-rollback timeout, and query cancellation through pg_cancel_backend on the tracked backend PID. Schema introspection is written to stay responsive on databases with hundreds of tables: the table tree renders from a first pass while relationships stream in from a second. Monitoring reads the pg_stat_* views, including pg_stat_statements where the extension is installed, and degrades to what the connected role can actually see instead of failing when superuser-only views are unavailable. The optional query assistant is constrained by the database rather than by prompt text. A run is given the real schema of the connected database before its first turn, so a drafted statement names objects that exist, and read-only runs execute inside BEGIN READ ONLY as a single statement over the extended protocol. Authentication is local accounts or OIDC, with role-based access control in front of every API route. The current release is 0.12.0. Source, documentation and the PostgreSQL provider reference are at github.com/libredb/libredb-studio and libredb.org.

## Loongson loong64 packages on apt.postgresql.org

DevFeed: [Loongson loong64 packages on apt.postgresql.org](<https://devfeed.tech/articles/loongson-loong64-packages-on-apt-postgresql-org-4717.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/loongson-loong64-packages-on-aptpostgresqlorg-3351/>)

Author: Apt Postgresql Org

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

Content type: news

Language: en

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

Topics: [apt](<https://devfeed.tech/topics/apt.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [cpu](<https://devfeed.tech/topics/cpu.md>), [Geographic Information System](<https://devfeed.tech/topics/gis.md>), [Exception](<https://devfeed.tech/topics/exception.md>)

Tags: [apt](<https://devfeed.tech/tags/apt.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [community](<https://devfeed.tech/tags/community.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

apt.postgresql.org now provides PostgreSQL packages for the Loongson loong64 architecture. The GIS package stack is still awaiting the next PostGIS release.

### Source excerpt

We have a new architecture on apt.postgresql.org: Loongson loong64, a Chinese processor architecture. The build host for the architecture is running on a Loongson 3B6000 board provided by the loongfans.cn community. Bootstrapping the PostgreSQL packages was completed earlier this month and everything is in place to be used via apt.postgresql.org. The exception is the GIS stack of packages (postgis, pgrouting, mobilitydb, pgsql-ogr-fdw) which are currently still waiting for the next postgis release. Enjoy, Christoph

## powa-archivist 5.3.0 is out!

DevFeed: [powa-archivist 5.3.0 is out!](<https://devfeed.tech/articles/powa-archivist-5-3-0-is-out-4723.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/powa-archivist-530-is-out-3366/>)

Published: 2026-08-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>), [releases](<https://devfeed.tech/topics/releases.md>), [benchmarking](<https://devfeed.tech/topics/benchmarking.md>), [monitor](<https://devfeed.tech/topics/monitor.md>), [Graphs](<https://devfeed.tech/topics/graphs.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [GitHub](<https://devfeed.tech/topics/github.md>)

Tags: [bugs](<https://devfeed.tech/tags/bugs.md>), [changelog](<https://devfeed.tech/tags/changelog.md>), [contributors](<https://devfeed.tech/tags/contributors.md>), [documentation](<https://devfeed.tech/tags/documentation.md>), [github](<https://devfeed.tech/tags/github.md>), [graphs](<https://devfeed.tech/tags/graphs.md>), [metrics](<https://devfeed.tech/tags/metrics.md>), [monitor](<https://devfeed.tech/tags/monitor.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [release](<https://devfeed.tech/tags/release.md>), [releases](<https://devfeed.tech/tags/releases.md>)

### AI overview

The PoWA team announces powa-archivist 5.3.0, a PostgreSQL Workload Analyzer extension that collects and aggregates metrics from multiple PostgreSQL instances, provides real-time charts and graphs for monitoring and tuning servers, and suggests index optimizations. The release also includes a fix for PostgreSQL 19 compatibility.

### Source excerpt

Tainan, Taiwan - Sun 16 Aug 2026 powa-archivist 5.3.0 The PoWA team is pleased to announce the release of the version 5.3.0 of powa-archivist, the core extension of the PoWA project. PoWA (PostgreSQL Workload Analyzer) is a performance tool, compatible with all supported PostgreSQL versions. It allows to collect and aggregate metrics gathered from multiple PostgreSQL instances using various extensions covering all parts of PostgreSQL and provides real-time charts and graphs to help monitor and tune your servers. It also suggest optimizations, like global or per-query index suggestions, to easily improve performances. Misc Fix pg19 compatibility with pg19beta2 pg_stat_lock.wait_time datatype change (Julien Rouhaud) Links & Credits Thank to the users who reported bugs or submitted patches, they are all cited in the CHANGELOG file and the CONTRIBUTORS file. powa-archivist 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/powa-team/powa-archivist. Links Documentation: powa.readthedocs.io/ Download: github.com/powa-team/powa-archivist/releases Bug tracker: github.com/powa-team/powa-archivist/issues