Skip to content

Instantly share code, notes, and snippets.

@v0112358
Last active January 2, 2020 14:23
Show Gist options
  • Save v0112358/654bd717cd3b53d6356648ee145b88e0 to your computer and use it in GitHub Desktop.
Save v0112358/654bd717cd3b53d6356648ee145b88e0 to your computer and use it in GitHub Desktop.
Install odyssey on CentOS 7

Odssey

Advanced multi-threaded PostgreSQL connection pooler and request router.

How to build odyssey on CentOS 7

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

systemd

# /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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment