System requirements
Software and hardware requirements for PostgreSQL HA solution.
Hardware requirements
A four node cluster deployment,
- Node Type 1 is PostgreSQL Server and
Patroni
nodeTwo or more nodes for PostgreSQL Server andPatroni
with minimum 4 GB RAM and 2 Core CPU.Note: Install thePatroni
and PostgreSQL server together on a node that is provisioned under Node Type 1. - Node Type 2 is
etcd
nodeA node with minimum 4 GB RAM and 2 Core CPU.
- Node Type 3 is
HAProxy
nodeA node with minimum 4 GB RAM and 2 Core CPU.
Note: Install theetcd
andHAProxy
on the nodes that are provisioned for them.
Make sure that the following TCP ports are available:
- 5432
- 2379
- 2380
- 8008
Software requirements
The following software is needed for the solution:
- RHEL V7.5
- OpenSSL V1.0.2k-fips
- PostgreSQL V11
- Patroni V1.5.6
- Etcd V2.2.5
- HAProxy V1.5.18