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 node
    Two or more nodes for PostgreSQL Server and Patroni with minimum 4 GB RAM and 2 Core CPU.
    Note: Install the Patroni and PostgreSQL server together on a node that is provisioned under Node Type 1.
  • Node Type 2 is etcd node

    A node with minimum 4 GB RAM and 2 Core CPU.

  • Node Type 3 is HAProxy node

    A node with minimum 4 GB RAM and 2 Core CPU.

    Note: Install the etcd and HAProxy 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