HA PostgreSQL¶

Onteon Tech HA solution for PostgreSQL® operates in active/passive mode. The primary cluster manager monitors and controls the operation of the PostgreSQL® nodes, as well as checking the availability of the secondary cluster manager. To avoid a single point of failure, the secondary cluster manager also monitors the availability of the primary cluster manager. Data from primary PostgreSQL® node are synchronized on the block level to the secondary, failover node.

Cluster aware backups can be made with dedicated backup & recovery software or Hetman from Onteon Tech can be used instead.

Architecture¶

HA PostgreSQL Architecture

Asynchronous Node¶

Onteon Tech HA solution for PostgreSQL® with the asynchronous node, consists of:

• primary cluster manager,
• secondary cluster manager,
• 2 synchronous nodes,
• 1 asynchronous node.

Data from the primary node are replicated asynchronously using PostgreSQL's® streaming replication. This method uses transaction log (WAL) to sychronize and replicate data in the cluster.

HA PostgreSQL Asynchronous Node Architecture