PostgreSQL Archives

Tech Optimizer

May 6, 2026

How Aurora Blue-Green Upgrades Cut Our Postgres Downtime by 50X

Paxos has implemented Blue-Green upgrades to improve database maintenance for asset trading, achieving a 50-fold reduction in downtime from 30-120 minutes to approximately one minute. This upgrade strategy allows for real-time synchronization between a blue cluster handling production traffic and a new green cluster with the updated version. Challenges included issues with CREATE ROLE statements disrupting upgrades due to temporary roles and the necessity to drop replication slots before PostgreSQL 17, which could lead to data loss. Additionally, upon the green cluster becoming primary, it acquires a new cluster ID, requiring updates for clients using RDS IAM authentication. The transition to PostgreSQL 17 is anticipated to resolve the need to drop logical replication slots, preserving Change Data Capture (CDC) continuity.

Tech Optimizer

May 6, 2026

Immudb Upgrade Brings Immutable Audit Trails To PostgreSQL Workloads – Open Source For You

Codenotary has released immudb 1.11, enhancing its open-source database into a comprehensive trust infrastructure layer. Key features include immutable audit logging, which allows organizations to create permanent, tamper-proof records of data and database activities, supported by cryptographic verification to prevent unauthorized alterations. The update also introduces compatibility with PostgreSQL, enabling existing applications to use immudb without modifications. Benefits for organizations include unalterable audit trails, simplified compliance and reporting, and reduced operational complexity. This release positions open source as a viable alternative to proprietary compliance and logging systems, addressing challenges in demonstrating data trustworthiness.

Tech Optimizer

May 5, 2026

Open Source Tamper-Proof Database Adds Immutable Audit Logging and Expands PostgreSQL Compatibility

Codenotary has released immudb 1.11, an open-source database that enhances immutable audit logging and compatibility with PostgreSQL. This version features integrated audit logging that captures database activities in a tamper-proof manner, eliminating the need for external logging systems. It allows organizations to create unalterable audit trails, streamline compliance processes, and maintain a reliable history of data interactions. Immudb 1.11 is compatible with existing PostgreSQL code, enabling seamless integration with various applications and tools. The database is particularly beneficial for sectors requiring trust and accountability, such as finance, software development, cybersecurity, regulated industries, AI systems, and supply chain management. Immudb has over 50 million downloads and supports a zero-trust approach to data management. The open-source version is available on GitHub.

Tech Optimizer

May 5, 2026

AI finds 20-year-old bugs in PostgreSQL and MariaDB

Patches have been released for all identified vulnerabilities in PostgreSQL and MariaDB, with strong recommendations for users to upgrade to the latest fixed versions. A zero-day flaw in PostgreSQL, classified as CVE-2026-2005, is a heap-based buffer overflow issue in the "pgcrypto" extension. This vulnerability allows attackers to exploit specially crafted input, leading to out-of-bounds writes and potential remote code execution on the database server. It affects all supported versions of PostgreSQL and has been addressed in updates v18.2, v17.8, v16.12, v15.16, and v14.21. The flaw has a high-severity rating of CVSS 8.8 out of 10 and has existed since 2005.

Tech Optimizer

May 5, 2026

A Long Story About How I Dug Into the PostgreSQL Source Code to Write my Own WAL Receiver

Researchers have unveiled a new AI model that enhances machine learning capabilities by streamlining data processing and improving predictive accuracy. The model incorporates advanced techniques for efficient training, leveraging deep learning algorithms and optimized data structures to analyze large datasets quickly and precisely. It offers enhanced data processing, scalability for growing business needs, and cost efficiency by reducing computational load. The model can learn from diverse data sources, making it adaptable for various applications and contributing to smarter decision-making and operational efficiencies.

Tech Optimizer

May 4, 2026

Wiz ZeroDay.Cloud Event Reveals 20-Year-Old PostgreSQL Vulnerabilities

Cybersecurity researchers at Wiz’s ZeroDay.Cloud event in London exploited two significant vulnerabilities in PostgreSQL, tracked as CVE-2026-2005 and CVE-2026-2006, which were disclosed on May 4, 2026. The vulnerabilities were found in the pgcrypto extension, affecting public-key decryption and symmetric decryption functions. CVE-2026-2005 allows privilege escalation via a buffer overflow during public-key decryption, while CVE-2026-2006 enables attackers to corrupt memory through inadequate checks in symmetric decryption. PostgreSQL has released patches for these vulnerabilities across versions 14.21 to 18.2, and MariaDB addressed a related issue in versions 11.4.10 and 11.8.6. Database administrators are advised to apply updates and audit logs for suspicious activity.

Tech Optimizer

May 4, 2026

How to Set Up PostgreSQL on Windows Easily in 2026

The installation process for PostgreSQL can be challenging for new users due to several factors. A common issue is the requirement to set a strong password for the default 'postgres' user, which users often forget, leading to a complicated reset process. Another challenge is port conflicts, as PostgreSQL uses port 5432 by default; if another application is using this port, it complicates installation. Additionally, users must configure PostgreSQL to be included in the system PATH for command-line operations, a step that is frequently overlooked, causing frustration when executing commands.

Tech Optimizer

May 3, 2026

ProxySQL Releases 3.0.6 And Advances AI Integration Roadmap

ProxySQL has released version 3.0.6, introducing a multi-tier strategy with three tiers: Stable, Innovative (3.1.x), and AI/MCP (4.0.x). Version 3.0.6 enhances PostgreSQL support, improves authentication mechanisms, updates Prometheus metrics, and refines macOS support. The Innovative tier features an embedded time-series database and a traffic observer. The AI/MCP tier explores native integrations for proxy-level Retrieval-Augmented Generation (RAG) and autonomous database management.

Tech Optimizer

May 3, 2026

EDB Releases WarehousePG Postgres Petabyte-Scale Warehouse

On March 31, 2026, EDB launched WarehousePG, an open-source data warehouse built on Postgres, designed for petabyte-scale analytics and in-database AI. It features real-time data ingestion, advanced vector processing for complex queries, and supports existing SQL workflows. Organizations migrating from proprietary data warehouses can achieve up to a 58% reduction in total cost of ownership. WarehousePG supports hybrid deployments and addresses data sovereignty concerns, allowing compliance with local regulations.

Tech Optimizer

May 3, 2026

TigerFS Mounts PostgreSQL As Transactional Filesystem

TigerFS is an open-source project introduced on April 4, 2026, by Michael Freedman, the CTO of TigerData. It allows users to mount a PostgreSQL database as a POSIX-like filesystem, storing database rows as individual files while ensuring ACID guarantees. Key features include an MIT license, support for both file-first and data-first workflows, mounting options using FUSE on Linux and NFS on macOS, and integration with standard Unix tools.