pgEdge has just released the latest version of its flagship product, pgEdge Platform v24.07, known as the Constellation Release. This update brings a host of new features designed to enhance the capabilities of distributed PostgreSQL databases. Building on its foundation as the only fully distributed PostgreSQL that is open (source code available) and based on standard PostgreSQL, pgEdge continues to lead the way in providing ultra-high availability and reduced latency across geographic regions. The Constellation Release introduces significant improvements, including advanced logical replication features, large object support, and enhanced error handling. These enhancements make pgEdge an even more powerful alternative for legacy multi-master replication technologies, offering greater throughput, flexibility, and control for users.

Key Enhancements in the Constellation Release

1. Large Object Logical Replication (LOLOR): With the new Large Object Logical Replication (LOLOR) feature, pgEdge ensures seamless integration for applications that store media assets and large files in PostgreSQL databases. This extension allows large objects to be compatible with logical replication, facilitating smoother transitions from legacy databases to PostgreSQL without requiring application modifications.  See blog for more details.

2. Replication Exception Handling and Logging: The latest update includes an advanced error handling and logging mechanism. Replication errors are logged into a new exception table, preventing disruptions in replication processes. This enhancement ensures a robust user experience, offering greater visibility and control over replication errors and making troubleshooting more straightforward. 

3. Replication Repair Mode: pgEdge now allows users to enable or disable "repair mode," providing the flexibility to manage replication processes without affecting the entire database cluster. This feature is particularly useful for controlling replication changes during error resolution or node-specific modifications.

4. Automatic Replication of DDL Commands: Updating the database schema has never been easier. With the automatic replication of DDL commands, any changes made to a single node are propagated across all nodes in the cluster. This feature simplifies the management of distributed PostgreSQL applications, especially during active development or maintenance.  See blog for more details.

5. Snowflake Sequence in Postgres Extension: To enhance sequence management in multi-master replication scenarios, pgEdge integrates Snowflake sequences within PostgreSQL. This extension ensures unique sequence numbers across different regions without needing application code or schema modifications, streamlining sequence management and improving scalability.  See blog for details and examples details.

Looking Ahead: High Performance Parallel Replication

pgEdge is set to introduce Parallel Replication in Q4 of this year. This feature will leverage multiple replication slots to enable parallel processing within distributed PostgreSQL clusters, significantly boosting replication throughput. It promises to reduce replication lag, ensuring timely data synchronization across nodes and maintaining data consistency even in high-demand environments.

Availability and Support

The pgEdge Platform is generally available as of July 31 and can be self-hosted on-premise or self-managed in the cloud with providers like AWS, Microsoft Azure, and Google Cloud Platform.   The new Constellation Release is available for download at https://www.pgedge.com/get-started/platform or can be accessed via GitHub.   pgEdge also offers enterprise-class support. Additionally, pgEdge Cloud, a fully managed service based on the pgEdge Platform, is available in beta and will be generally available in Q3.

View the full press release here or visit www.pgedge.com for more information about pgEdge distributed PostgreSQL.