OpenProxy

OpenProxy is a Rust-based server process that functions as a proxy for PostgreSQL databases, providing connection pooling, query-based load balancing, database sharding, and failover using virtual IP (VIP).

This document describes how to install OpenProxy from an OpenSQL package created using the OpenSQL packaging tool.

---

Installation

1. Configuring Openproxy

The $OPENSQL_INSTALL_HOME/openproxy directory in the OpenSQL package contains the following three files.

• Openproxy binary openproxy

• Configuration file required to run (openproxy.toml)

• Service file required for systemd registration (openproxy.service)

[root@5c9e5c6ae5f2 openproxy]# ls
openproxy  openproxy.service  openproxy.toml

You can configure OpenProxy using the supplied configuration files and register it as a service via systemd.

2. Setting OPENSQL_INSTALL_HOME directory

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

3. Installing Openproxy

sudo -E ./install_rpm.sh openproxy

4. Verifying Binary execution

You can check the version of binary with the command below.

[root@5c9e5c6ae5f2 openproxy]# openproxy --version
openproxy 1.0.0