FAQ: pgEdge Platform v25 Release - Key Features and Benefits

What is pgEdge Platform v25 and what does it offer?

pgEdge Platform v25 is the latest release of pgEdge’s distributed PostgreSQL solution, offering significant improvements including true zero downtime for node additions and PostgreSQL upgrades, expanded automatic conflict resolution, improved performance, interactive installation, and integrated backup capabilities with pgBackrest.

Why is the zero downtime capability important for users?

The zero downtime capability allows users to add new nodes and perform PostgreSQL version upgrades without interrupting write operations, ensuring their cluster remains Always-On and Write-Anywhere throughout maintenance operations.

How does the expanded automatic conflict resolution work in v25?

The expanded conflict resolution automatically handles scenarios like Insert-RowExists (converting second inserts to updates), Delete-RowMissing (resolving as desired behavior), and can be configured to check for non-null Unique Constraint violations using Last-Write-Wins resolution.

What performance improvements are included in Platform v25?

v25 includes overhauled Exception Handling that performs in-memory for order-of-magnitude speed improvements, and improved Lag Monitoring that calculates at the target node for better accuracy and prevents increasing reported lag during no-write-activity periods.

How does the new interactive installation benefit users?

The interactive installation guides customers through required information and creates configuration files automatically, making cluster setup easier especially for first-time users and ensuring proper configuration file creation.

What backup and restore capabilities are included in v25?

v25 includes pgBackrest as a default part of the platform configuration for easy backup setup, along with a backup & restore Strategy Guide to help customers get started with their backup strategy.

How does pgEdge Platform compare to other distributed database solutions?

According to the content, pgEdge Platform is positioned as the only distributed Postgres solution that is open source available and completely based on standard PostgreSQL, making it a viable open source alternative for workloads requiring multi-master capability.

What types of PostgreSQL version upgrades does v25 support with zero downtime?

v25 supports both major and minor PostgreSQL version upgrades as rolling updates by adding a new upgraded node and decommissioning the old node, instead of taking nodes offline for upgrades.

Who is the target audience for pgEdge Platform v25?

The platform targets users with legacy database workloads requiring multi-master capability who need a distributed PostgreSQL solution that is open source and based on standard PostgreSQL.