Advanced multi-threaded PostgreSQL connection pooler and request router.
yum install git cmake postgresql11-devel openssl-devel zlib-devel gcc -y
PATH=$PATH:/usr/pgsql-11/bin/
export PATH
LD_LIBRARY_PATH=/usr/pgsql-11/lib/
export LD_LIBRARY_PATH
ldconfig /usr/pgsql-11/lib/
git clone https://github.com/yandex/odyssey
cd odyssey/
cmake -DPQ_LIBRARY=/usr/pgsql-11/lib/libpq.a -DCMAKE_BUILD_TYPE=Release .
make
mv sources/odyssey /usr/bin/odyssey
# /usr/lib/systemd/system/odyssey.service
[Unit]
Description=Advanced multi-threaded PostgreSQL connection pooler and request router
After=network.target
[Service]
User=odyssey
Group=odyssey
Type=simple
ExecStart=/usr/bin/odyssey /etc/odyssey/odyssey.conf
LimitNOFILE=100000
LimitNPROC=100000
[Install]
WantedBy=multi-user.target