OpenProxy 설정 레퍼런스

[general.etcd]
enabled = true
endpoints = [
    "192.168.1.1:2379",
    "192.168.1.2:2379",
    "192.168.1.3:2379",
]
patroni_namespace = "/service"
patroni_scope = "postgres-cluster"

# etcd 인증이 설정된 경우
# username = "etcduser"
# password = "etcdpassword"

[general.virtual_router]
interface = "eth0"
router_id = 50
priority = 100
advert_int = 1
vip_addresses = ["192.168.1.100/24"]

[pools.mydb]
pool_mode = "transaction"
auth_type = "scram-sha-256"
query_parser_enabled = true
query_parser_read_write_splitting = true

[pools.mydb.users.0]
username = "appuser"
password = "apppassword"
server_username = "appuser"
server_password = "apppassword"
pool_size = 20
statement_timeout = 0

[pools.mydb.users.1]
username = "*"
pool_size = 10
statement_timeout = 0

[pools.mydb.shards.0]
servers = [
    ["192.168.1.10", 5432, "primary"],
    ["192.168.1.11", 5432, "replica"],
    ["192.168.1.12", 5432, "replica"],
]
database = "mydb"

[pools.mydb.shards.0]
servers = [
    ["192.168.1.10", 5432, "Auto"],
    ["192.168.1.11", 5432, "Auto"],
    ["192.168.1.12", 5432, "Auto"],
]
database = "mydb"
use_patroni = true

[general]
host = "0.0.0.0"
port = 6432
admin_username = "openproxy_admin"
admin_password = "adminpassword"

[pools.mydb]
pool_mode = "transaction"
auth_type = "scram-sha-256"

[pools.mydb.users.0]
username = "appuser"
password = "apppassword"
server_username = "appuser"
server_password = "apppassword"
pool_size = 20

[pools.mydb.shards.0]
servers = [
    ["192.168.1.10", 5432, "primary"],
]
database = "mydb"

[general]
host = "0.0.0.0"
port = 6432
admin_username = "openproxy_admin"
admin_password = "adminpassword"
worker_threads = 4

[general.etcd]
enabled = true
endpoints = [
    "192.168.1.1:2379",
    "192.168.1.2:2379",
    "192.168.1.3:2379",
]
patroni_namespace = "/service"
patroni_scope = "postgres-cluster"

# VRRP를 사용하는 경우 활성화
# [general.virtual_router]
# interface = "eth0"
# router_id = 50
# priority = 100
# advert_int = 1
# vip_addresses = ["192.168.1.100/24"]

[pools.mydb]
pool_mode = "transaction"
auth_type = "scram-sha-256"
query_parser_enabled = true
query_parser_read_write_splitting = true

[pools.mydb.users.0]
username = "appuser"
password = "apppassword"
server_username = "appuser"
server_password = "apppassword"
pool_size = 20

[pools.mydb.shards.0]
servers = [
    ["192.168.1.10", 5432, "Auto"],
    ["192.168.1.11", 5432, "Auto"],
    ["192.168.1.12", 5432, "Auto"],
]
database = "mydb"
use_patroni = true

[general.default_pool]
pool_mode = "transaction"

## 기타 Pool General 설정
auth_type = "scram-sha-256"
auth_query = "SELECT usename, passwd FROM pg_shadow WHERE usename = '$1'"
auth_query_user = "opensql"
auth_query_password = "opensql"

[general.default.pool.users.0]
## 이 값은 실제로 참조되지 않습니다. 클라이언트의 username을 참조하여 DB 연결을 생성합니다.
username = "*"
pool_size = 20
statement_timeout = 0

[general.default_pool.shards.0]
servers = [
    [ "pg-1", 5432, "auto" ],
    [ "pg-2", 5432, "auto" ]
]
## auth_query를 실행할 때만 참조되며 클라이언트 연결 시에는 실제로 참조되지 않습니다.
## 클라이언트의 DB name을 참조하여 DB 연결을 생성합니다.
database = "postgres"
use_patroni = true

[pools.mydb]
## 기존 Pool 정의
auth_type = "scram-sha-256"
auth_query = "SELECT usename, passwd FROM pg_shadow WHERE usename = '$1'"
auth_query_user = "opensql"
auth_query_password = "opensql"

[pools.mydb.users.0]
username = "*"
pool_size = 35
statement_timeout = 0