Introduction to pgEdge
pgEdge supports a true multi-active(multi-master) distributed database system that supports secure read and write operations on any publisher or subscriber node of a replication scenario.
In a distributed PostgreSQL system, a replicated cluster can span multiple cloud regions or data centers. This is advantageous if your international regulations require data generated in a certain country or region stay in that country of origin. With pgEdge, you control which tables are globally replicated, and which stay local. Geo-sharding allows you to break out tables by location field; global data is then shared globally, while local data stays local.
pgEdge Cloud is fully-distributed PostgreSQL, deployable across multiple cloud regions or data centers.
pgEdge Cloud provides:
- cloud-agnostic architecture
- ultra high-availability
- disaster recovery capabilities
- data residency
- compliance adherence
- business continuity
These benefits collectively help mitigate risk by removing dependency on a single cloud provider and enhancing overall system resilience and flexibility.
pgEdge Platform is the most complete and advanced distribution of open-source PostgreSQL, with extended support for multi-active (multi-master) PostgreSQL databases. pgEdge Platform includes:
- PostgreSQL (versions 15 and 16)
- the Spock multi-active logical replication extension
- NodeCtl - the pgEdge node controller
- PostgREST web API extension
- Popular PostgreSQL extensions, including pgVector, pgCAT, pgBackRest, PostGIS, plprofiler, and foreign data wrappers
Spock is a PostgreSQL extension that provides multi-master (multi-active) replication for PostgreSQL 15 and 16. One provider node may feed multiple subscriber nodes without incurring additional disk write overhead. A subscriber can merge changes from multiple origins and detect conflict between changes with automatic and configurable conflict resolution.
- Asynchronous multi-active replication with conflict resolution
- Upgrades between major versions
- Full database replication
- Selective replication of sets of tables using replication sets
- Selective replication of table rows at either publisher or subscriber side (
- Selective replication of partitioned tables
- Selective replication of table columns at publisher side
- Data gather/merge from multiple upstream servers
See The Spock Extension (opens in a new tab) for more information about the commands you can use to manage Spock.