# edb-ref-archs

**Repository Path**: mirrors_EnterpriseDB/edb-ref-archs

## Basic Information

- **Project Name**: edb-ref-archs
- **Description**: EDB Reference Architectures
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-09-17
- **Last Updated**: 2026-05-23

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

![EDB Logo](images/logo.png "EDB Logo")

# EDB Reference Architectures

## Introduction

This repository contains reference architectures and supporting materials and 
code for the deployment of 
[EDB Postgres Advanced Server](https://www.enterprisedb.com/products/edb-postgres-advanced-server-secure-ha-oracle-compatible),
[PostgreSQL](https://www.postgresql.org) and related tools for high availability,
monitoring, and management.

## Selecting an Architecture

The reference architectures offered are split into the core database server
and a number of optional add ons.

Each database server architecture is designed to meet different needs and 
requirements, offering a range of scalability and availability and redundancy
options offering different levels of:

* [Recovery Time Objective](https://en.wikipedia.org/wiki/Disaster_recovery#Recovery_Time_Objective) (RTO)
* [Recovery Point Objective](https://en.wikipedia.org/wiki/Disaster_recovery#Recovery_Point_Objective) (RPO)
* Geographic Redundancy Objective (GRO)
* [Target Availability](https://en.wikipedia.org/wiki/Availability)

Select and implement the most appropriate reference architecture to meet your
needs, and then implement one or more of the Add On options to provide the
additional functionality you require.

### Database Clusters

* [Single node](single-node)
* [Multi node with asynchronous replication](multi-node-async)
* [Multi node with synchronous replication](multi-node-sync)

Architecture     | Redundancy | Automatic Failover | Multi node commit | Recommended Use                                 |
-----------------|:----------:|:------------------:|:-----------------:|-------------------------------------------------|
Single Node      | No         | No                 | No                | Development/testing                             |
Multi Node Async | Yes        | Yes                | No                | Production, with transaction loss acceptable    |
Multi Node Sync  | Yes        | Yes                | Yes               | Production, with no transaction loss acceptable |

### Add Ons

#### Poolers and Query Routers

* [Load balancing with pgBouncer](pgbouncer)
* [Load balancing and query routing with pgPool](pgpool)

Add On    | Load balancing | Query Routing |
----------|:--------------:|:-------------:|
pgBouncer | Yes            | No            |
pgPool    | Yes            | Yes           |

#### Administration

* [Monitoring with Postgres Enterprise Manager (PEM)](edb-pem)
* [Backup & Recovery with Backup and Recovery Tool (BART)](edb-bart)

## Improvements and Issues

If you want to suggest any improvements or report any problems you may have 
found, please create a 
[Pull Request](https://github.com/EnterpriseDB/edb-ref-archs/pulls) or log an
[Issue](https://github.com/EnterpriseDB/edb-ref-archs/issues).

## License

The contents of this repository are licensed under the 
[PostgreSQL License](LICENSE.md).