> For the complete documentation index, see [llms.txt](https://docs.tibero.com/tmaxopensql/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tibero.com/tmaxopensql/installation/binary/openproxy.md).

# 오픈 프록시(OpenProxy)

## 개요

오픈프록시(OpenProxy)는 Rust 기반 서버 프로세스로 PostgreSQL 데이터베이스에 대한 커넥션 풀링, 쿼리 라우팅을 통한 로드밸런싱, 데이터베이스 샤딩 및 가상 IP 기반 Failover 기능을 제공하는 프록시 서버입니다.

본 문서는 OpenSQL 패키징 툴을 이용해 작성한 OpenSQL 패키지로부터 OpenProxy를 설치하는 방법에 대하여 기술합니다.

***

## 설치

### 1. Openproxy 구성

OpenSQL 패키지 내 `$OPENSQL_INSTALL_HOME/openproxy` 디렉토리에는 Openproxy 구동에 필요한 다음 세가지 파일이 포함되어 있습니다.

* Openproxy 바이너리 `openproxy`
* 구동에 필요한 설정 파일 (`openproxy.toml`)
* systemd 등록에 필요한 service 파일 (`openproxy.service`)

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

파일들을 사용하여 OpenProxy를 설정하고 systemd를 통해 서비스로 등록할 수 있습니다.<br>

### 2. OPENSQL\_INSTALL\_HOME 디렉토리 설정

```bash
. ./setenv.sh `pwd`
OPENSQL_INSTALL_HOME is set to: /home/opensql3.0-rockylinux9.4-pg16.8
OPENSQL_HOME is set to: /home/opensql
OPENSQL_HOME added to /home/opensql/.bashrc
```

### 3. Openproxy 설치

<pre class="language-bash"><code class="lang-bash"><strong>./install.sh openproxy
</strong></code></pre>

### 4. 바이너리 구동 여부 확인

아래 명령어를 통해 바이너리의 버전을 확인할 수 있습니다.

```bash
[root@5c9e5c6ae5f2 openproxy]# openproxy --version
openproxy 1.1.0
```

###


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.tibero.com/tmaxopensql/installation/binary/openproxy.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.