PostgreSQL Archives

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.

Tech Optimizer

May 3, 2026

Absurd Delivers Durable Workflows On Postgres

On April 4, 2026, Earendil reported on Absurd, an execution system built solely on Postgres, which has been in production for five months and has received several updates. Recent developments include the introduction of Software Development Kits (SDKs) for TypeScript, Python, and an experimental Go SDK, as well as a command-line interface (CLI) called absurdctl and a Habitat dashboard for monitoring and management. Absurd's architecture is resilient, utilizing a checkpointed step model for durable agent workflows, but currently lacks features like partitioning and built-in push scheduling, focusing on reliability and simplicity.

Tech Optimizer

May 3, 2026

PostgreSQL 18 Enables AI-Ready Data Systems

PostgreSQL 18 addresses the challenges of data quality and integration in artificial intelligence, emphasizing the importance of the relationship between AI embeddings and relational data. It features pgvector, a tool that helps maintain this relationship and reduces reliance on fragile code. The accompanying resources include working schemas, implementation scripts, and a demo showcasing the system's capabilities with evidence rows and explanations from a large language model. The approach combines semantic candidate retrieval with SQL filtering and business rule enforcement, enhancing the reliability of AI outputs and ensuring data accuracy.