Patroni

Patroni is a Python 3-based server process and template that provides lifecycle management of PostgreSQL database instances installed on nodes, high availability management through cluster configuration, and cluster management through REST APIs.

---

Installation

The node must have a PostgreSQL server installed and the postgres user configured. Patroni manages the life cycle of the PostgreSQL server directly at runtime by referencing the PostgreSQL server's Data Directory and Binary Directory, which are included in the definition of its PostgreSQL configuration values.

Requirement

• The node intended for Patroni installation must be configured with a PostgreSQL server.

• In OpenSQL, the Distributed Configuration Store (DCS), such as etcd, must be running before starting Patroni.

1. Setting OPENSQL_INSTALL_HOME directory

. ./setenv.sh `pwd`
OPENSQL_INSTALL_HOME is set to: /home/opensql3.0-rockylinux9.4-pg16.8 

2. Installing Patroni

sudo -E ./install_rpm.sh patroni

3. Veryfying Patroni installation

Once installed, you can check the version of patroni and patronictl with the command below.

[root@396dd54381db scripts]patroni --version
patroni 4.0.3

[root@396dd54381db scripts] patronictl version
patronictl version 4.0.3