- BFSIBanking, Financial Services & Insurance
- HealthcareComing soon
- ManufacturingComing soon
- Retail & E-CommerceComing soon
EDB Postgres Distributed (PGD)
For the workloads that cannot go down — EDB Postgres Distributed (PGD) runs active-active, geo-distributed Postgres clusters at up to 99.999% availability, with no failover gap and even online major-version upgrades, on open Postgres.
How it’s rated
Full scoreboard ↓Quick answer
EDB Postgres Distributed (PGD) is EDB's extreme high-availability solution — active-active, geo-distributed Postgres clusters delivering up to 99.999% availability (‘five nines’) for mission-critical, latency-sensitive workloads that simply cannot go down. Standard database high availability uses a single primary with passive standby replicas: if the primary fails, a standby is promoted, but there's a failover gap and the standbys don't serve writes. PGD is different — it's active-active: multiple database nodes, potentially spread across geographic locations, all accept writes simultaneously. That delivers both very high availability (there's no single primary to fail; if a node goes down, others keep serving) and low latency for geographically-distributed applications (users write to their nearest node). PGD also enables online maintenance and even online major-version upgrades — so you can patch, maintain and upgrade the database without taking it down, eliminating planned-downtime windows. For core banking, telecom, critical government services and any workload where downtime is unacceptable and five-nines availability (about five minutes of downtime per year) is the requirement, PGD is EDB's answer — and a key reason organisations run their most important workloads on EDB Postgres.
The EDB Postgres platform family
This page covers Distributed HA (PGD) — extreme availability. The rest of the portfolio:
Quick facts
30-second orientation- Product
- EDB Postgres Distributed (PGD)
- Vendor
- EDB (EnterpriseDB) — part of IBM
- What
- Active-active, geo-distributed Postgres HA
- Availability
- Up to 99.999% (‘five nines’)
- The model
- Multiple nodes all accept writes (not single-primary)
- Also
- Low latency for geo-distributed apps
- Key feature
- Online maintenance & major-version upgrades
- Eliminates
- Failover gaps AND planned-downtime windows
- For
- Mission-critical, latency-sensitive workloads
- In India via
- TechBag — quotes, PoCs, GST invoicing, Tier-1 support
Understand active-active HA before you buy it
Most product pages skip this. We start here — so you buy a capability, not a buzzword.
What is PGD?
EDB's active-active, geo-distributed Postgres high availability — multiple nodes all accept writes, delivering up to 99.999% uptime.
Plus online maintenance and even major-version upgrades without downtime.
Single-primary HA vs active-active PGD — the honest table
What consolidation actually replaces, dimension by dimension.
| Dimension | Single-primary (failover gap) | PGD (active-active, five nines) |
|---|---|---|
| HA model | Single primary + standbys | Active-active, all nodes write |
| Failover | Gap (seconds–minutes) | No gap — others keep serving |
| Availability | Lower nines | Up to 99.999% |
| Writes | Only the primary | All nodes |
| Latency (geo) | Round-trip to primary | Local writes, low latency |
| Maintenance | Downtime windows | Online, no downtime |
| Major upgrades | Disruptive downtime | Online, no downtime |
| vs Oracle RAC | Proprietary, expensive | Open Postgres, no lock-in |
Extreme HA on open Postgres — active-active is complex, for workloads that genuinely need it; standard needs suit single-primary.
The five pieces of the platform
Vendors love diagrams; buyers need to know what they’re actually operating. Here’s the whole platform, demystified.
Active-Active Cluster
Multiple database nodes all accept writes simultaneously — no single primary to fail. If a node goes down, the others keep serving, with no failover gap.
Geo-Distribution
Nodes can be spread across geographic locations — users write to their nearest node, giving low latency for geographically-distributed applications.
Conflict Resolution
Manages the write conflicts inherent in multi-node writes — the sophisticated machinery that makes active-active Postgres work reliably.
Online Operations
Online maintenance and even online major-version upgrades — patch, maintain and upgrade without taking the database down, eliminating planned-downtime windows.
Fast Failover
Automatic, fast handling of node failures — the cluster keeps serving, delivering up to 99.999% availability.
One agent on every machine, one console over all of them — modules attach without a second operational world.
Twelve capabilities. Availability, distributed, operate.
PGD runs active-active Postgres — all nodes write, no single primary to fail — delivering five-nines availability and zero-downtime upgrades.
Active-Active Writes
Multiple nodes all accept writes — no single primary to fail, no write bottleneck.
Up to 99.999% Uptime
‘Five nines’ availability — about five minutes of downtime per year, for workloads that can't go down.
No Failover Gap
If a node fails, others keep serving — no primary-promotion gap where the database is unavailable.
Geo-Distributed
Nodes across locations — users write to their nearest node, low latency for distributed apps.
Low Latency
Local writes for geographically-distributed users — not a round-trip to a distant primary.
Conflict Resolution
Handles multi-master write conflicts reliably — the machinery that makes active-active work.
Online Maintenance
Patch and maintain the database without downtime — no more planned-maintenance windows.
Online Major Upgrades
Even major-version upgrades without taking the database down — a genuinely rare, valuable capability.
Read/Write Scale
Distribute load across nodes — availability and scalability together.
On Open Postgres
Extreme HA on true open Postgres — runs anywhere, no lock-in.
EDB (IBM) Support
Enterprise support for your most critical HA workloads — the safety net that matters most here.
On Extended/Advanced Server
Built on EDB's enterprise Postgres — the HA layer for your migrated or Postgres-native workloads.
Watch EDB Postgres Distributed in action
Active-active, geo-distributed Postgres HA and five-nines availability.
Introducing EDB Postgres AI
EDB's sovereign data-and-AI platform built on Postgres, introduced by EDB.
EDB Postgres AI: Enterprise-Grade Postgres
What makes EDB's Postgres enterprise-grade — HA, security, support.
Postgres Architect Answers AI & Data Questions
An EDB Postgres architect fields real AI and data questions.
Want a live, India-context walkthrough on your own fleet?
Book a guided demo →A single primary can fail. Active-active doesn’t.
Here’s what genuinely sets EDB Postgres Distributed (PGD) apart from the alternatives.
Active-active beats single-primary HA
Standard database HA uses a single primary with passive standby replicas — if the primary fails, a standby is promoted, but there's a failover gap (seconds to minutes where the database is unavailable) and the standbys don't serve writes. PGD is active-active: multiple nodes all accept writes simultaneously, so there's no single primary to fail, and if a node goes down the others keep serving with no gap. That fundamentally higher-availability model is why PGD reaches up to 99.999% — five nines — which single-primary HA struggles to match.
Five nines: for workloads that can't go down
99.999% availability means about five minutes of unplanned downtime per year. That level of availability is required for the workloads where downtime is genuinely unacceptable — core banking systems, telecom infrastructure, critical government services, payment processing. For these, ‘the database is down’ isn't an inconvenience, it's a crisis with real financial, regulatory and reputational cost. PGD is EDB's answer for exactly these mission-critical workloads, delivering the extreme availability their SLAs demand on open Postgres.
Low latency for geo-distributed apps
Because PGD nodes can be spread across geographic locations and all accept writes, users write to their nearest node rather than making a round-trip to a single distant primary. For applications with geographically-distributed users, that local-write capability delivers low latency alongside high availability — two benefits from one architecture. A global application gets both fast local performance and resilience against any single location failing, which single-primary architectures can't provide.
Upgrade without downtime — genuinely
Here's a capability that sounds mundane but is genuinely valuable and rare: PGD enables online maintenance and even online major-version upgrades — you can patch, maintain and upgrade the database without taking it down. Planned-maintenance windows (‘the system will be down Sunday 2–6am for a database upgrade’) are a real operational and business burden, and major-version database upgrades are notoriously disruptive. Eliminating that planned downtime, on top of the unplanned-downtime protection, is a significant part of PGD's value — true continuous availability, planned and unplanned.
Extreme HA, on open Postgres
PGD delivers this active-active, five-nines availability on true open PostgreSQL — so you get the extreme resilience your mission-critical workloads need without proprietary lock-in, running anywhere (on-prem, any cloud, hybrid), built on EDB's enterprise Postgres (Extended or Advanced Server). For organisations that both need extreme availability AND want to avoid the cost and lock-in of proprietary HA solutions (like Oracle RAC), PGD on open Postgres is a compelling combination — mission-critical resilience with open-source freedom.
The honest positioning
PGD is a leading active-active distributed HA solution for Postgres — its five-nines availability and online upgrades are genuine strengths. Active-active/multi-master is architecturally complex (conflict resolution needs care, and application design matters), so it's for workloads that genuinely need extreme HA, not every database. Alternatives include single-primary Postgres HA (simpler, lower availability), Oracle RAC (proprietary, expensive), and distributed-SQL databases (Yugabyte, CockroachDB — different architecture). For extreme Postgres HA with online upgrades on open Postgres, PGD leads. TechBag scopes whether your workload needs it.
The numbers behind the platform
What your EDB Postgres Distributed (PGD) journey looks like
Availability scoping
Your mission-critical workloads, availability SLA (do you truly need five nines?), and geo-distribution needs. TechBag scopes it free.
PGD PoC
Stand up an active-active PGD cluster; test failover (a node down, cluster keeps serving), geo-writes and an online upgrade.
HA design & app fit
Design the cluster topology; address conflict-resolution and application design for active-active; plan the migration to PGD.
Five-nines steady state
Mission-critical Postgres with active-active five-nines availability and zero-downtime upgrades. TechBag models it in INR/GST.
Trusted across regulated industries in 100+ countries
The review scoreboard
Modelled on Gartner Peer Insights structure. *Counts and breakdowns are illustrative pending verified review collection.
Quick poll — what’s driving your evaluation?
Talk to an advisor“Our core banking database cannot go down — PGD's active-active model reached five-nines availability. No single primary to fail, no failover gap. For mission-critical workloads, this is the answer.”
“Online major-version upgrades — without downtime — eliminated our dreaded planned-maintenance windows. That capability alone transformed our operations. True continuous availability.”
“Geo-distributed active-active meant our global users write to their nearest node — low latency AND resilience against any location failing. Two benefits, one architecture.”
“Extreme HA on open Postgres, not proprietary Oracle RAC — mission-critical resilience without the licensing and lock-in. That combination sold it.”
“Active-active is architecturally complex — conflict resolution and app design need care — but for our workload that genuinely can't go down, it was worth it. Scope whether you truly need extreme HA.”
“Five minutes of downtime a year vs the hours our old single-primary HA cost us in failover gaps and maintenance windows — the availability difference was night and day.”
“It builds on our EDB Postgres — the HA layer for our mission-critical workloads. Freedom from Oracle AND five-nines availability from one vendor.”
“For non-critical databases single-primary HA is simpler and fine — PGD is for the workloads where downtime is a crisis. We use it exactly there.”
Where everyone sits — the grids
Analyst firms bury this view behind paywalls, and G2 retired its Grid. So here’s TechBag’s synthesis of the active-active HA market — tap any vendor to see why it sits where it does.
TechBag Postgres HA Grid
Execution strength vs product vision — the classic market map, minus the paywall.
Active-active, five-nines Postgres HA — this page.
Availability × Openness
The grid nobody publishes — availability (active-active, five nines) vs openness (open Postgres, no proprietary lock-in).
Active-active + online upgrades + open — the corner it fills.
Positions are TechBag’s illustrative synthesis of public review-platform data and vendor documentation — not a reproduction of any analyst graphic. Verify before relying on it.
EDB Postgres Distributed vs the field
Single-primary HA, Oracle RAC and distributed SQL — honest lanes; the edge is active-active five-nines on open Postgres.
| Dimension | EDB Postgres Distributed | Single-primary Postgres HA | Oracle RAC | Yugabyte / Cockroach | No HA |
|---|---|---|---|---|---|
| HA model | Active-active, geo | Primary + standby | Active-active (Oracle) | Distributed SQL | None |
| Availability | Up to 99.999% | Lower | Very high | High | Low |
| Online upgrades | Yes (major too) | Downtime | Complex | Rolling | Downtime |
| Open / no lock-in | Open Postgres | Open Postgres | Oracle-locked | Postgres-compat | Depends |
| Best fit | Mission-critical Postgres that can't go down | Standard HA needs | Oracle RAC shops | Distributed-SQL adopters | Nobody critical |
Which HA approach fits you?
Honest fit signals — because the fastest way to lose your trust is to pretend one product wins every scenario.
Choose EDB Postgres Distributed (PGD) if…
- ✓Your workload genuinely cannot go down (five-nines needed)
- ✓You want active-active, geo-distributed Postgres HA
- ✓Online (incl. major-version) upgrades matter
- ✓You want extreme HA on open Postgres, not proprietary RAC
Single-primary Postgres HA if…
- ✓Standard availability needs — simpler, lower cost
Oracle RAC if…
- ✓You're deeply Oracle-committed (or migrate to PGD)
Yugabyte / Cockroach if…
- ✓You want a distributed-SQL database (different architecture)
No HA if…
- ✓Never for anything important — it's a single point of failure
What does downtime cost you?
Drag the sliders (count mission-critical DB instances; IT-hour cost as a proxy for downtime cost per hour). Estimates model the annual downtime cost of single-primary HA (failover gaps + maintenance windows), with ~65% representative of the reduction from active-active five-nines with online upgrades — the avoided-downtime value for truly can’t-go-down workloads dwarfs the licensing. Illustrative.
Loaded cost = salary + overheads per productive hour. Illustrative only — your TechBag quote models actual device counts and modules.
Three ways to consume it
PGD prices as an add-on / subscription on EDB Postgres. TechBag models it vs Oracle RAC or downtime cost, in INR/GST.
PGD
Best for extreme HA
- Active-active, geo-distributed
- Up to 99.999% availability
- No failover gap
+ Online ops
Best for always-on
- Online maintenance
- Online major-version upgrades
- No planned-downtime windows
+ Open Postgres
Best vs Oracle RAC
- Runs anywhere, no lock-in
- On EDB enterprise Postgres
- TechBag scopes HA + migration
Buy it for less — TechBag pricing beats list
Whatever the list prices above, TechBag negotiates a significantly better deal — with GST-compliant INR invoicing and local support. Ask us for your discounted quote.
Get an India-ready quote
Tell us your device counts and current tools — we’ll model it against what you spend today.
The 8 questions to ask every Postgres HA vendor
Take this into your next vendor call — including ours.
Confirm your workload genuinely can't go down — PGD is for mission-critical HA, not every database (single-primary suits standard needs).
Take a node down in a PoC — confirm the cluster keeps serving with no failover gap.
Test an online major-version upgrade — confirm it happens without downtime. A rare, valuable capability.
If your users are distributed, test local writes to the nearest node — low latency plus resilience.
Understand the active-active conflict-resolution and application-design implications — multi-master needs care.
Confirm it's on open Postgres — extreme HA without proprietary RAC lock-in.
Confirm EDB (IBM-backed) support — the safety net matters most for your most critical workloads.
Model PGD TCO vs Oracle RAC or downtime cost — TechBag quotes it in INR/GST.
Questions buyers ask
Ready to evaluate EDB Postgres Distributed (PGD)?
Scope a PGD PoC (test active-active failover and an online upgrade), or let a TechBag advisor design five-nines Postgres HA — in INR/GST.
Stats, ratings, review counts and pricing are illustrative and sourced from public materials; verify before purchase.