pgEdge Platform v25 Enhances Distributed PostgreSQL with Zero Downtime Upgrades and Expanded Automation
pgEdge's latest platform release introduces significant improvements to distributed PostgreSQL, including true zero downtime for node additions and version upgrades, expanded automatic conflict resolution, and enhanced performance features that strengthen its position as an open-source alternative for multi-master database workloads.
pgEdge, Inc. announced the availability of pgEdge Platform v25, building upon its industry-leading distributed PostgreSQL solution with several critical enhancements. The new release solidifies pgEdge's position as the only open-source distributed PostgreSQL platform completely based on standard PostgreSQL, offering significant improvements in availability, conflict resolution, and performance for enterprise database workloads requiring multi-master capabilities.
Platform v25 introduces true zero downtime for node addition and PostgreSQL upgrades, enabling customers to add new nodes without write downtime and perform major version upgrades through rolling updates rather than taking nodes offline. This Always-On, Write-Anywhere approach ensures clusters remain fully operational while bringing new nodes online or upgrading existing infrastructure. The company continues to enhance this zero downtime capability as a core feature of its distributed architecture.
Expanded automatic conflict resolution now handles broader scenarios including Insert-RowExists conflicts where two inserts with the same primary key automatically convert the second insert into an all-column update, and Delete-RowMissing scenarios where attempts to delete non-existent rows are automatically resolved according to desired behavior. The platform also now checks for non-null unique constraint violations and attempts resolution with last-write-wins updates.
Performance improvements include overhauled exception handling that can now be performed in-memory, providing an order-of-magnitude speed improvement over traditional pgLogical methods. Lag tracking has been enhanced with calculations performed at the target node, improving accuracy and preventing ever-increasing reported lag during periods without write activity to replicate.
The release features an interactive installation process that guides customers through configuration file creation, making cluster setup easier for first-time users while ensuring proper configuration. Backup and restore capabilities have been strengthened with pgBackrest integration as a default platform component, eliminating the need for users to find and install separate backup methods while providing comprehensive strategy guidance.
Substantial enhancements to the Active Consistency Engine (ACE) deliver faster performance, improved flexibility, and expanded automation for detecting and resolving data discrepancies across nodes, particularly beneficial for large-scale datasets. According to Phillip Merrick, Co-founder and CEO of pgEdge, these features were designed in collaboration with customers and partners to make the product easier to use while enhancing distributed PostgreSQL capabilities for high availability and low latency requirements.