Odyssey

Spec sheet

Purpose

Odyssey is an advanced, multithreaded PostgreSQL connection pooler and request router.Read 4 Oct 2026 · pg-odyssey.tech

Deployment

Odyssey can be installed from the PGDG repository, run from a public Docker image, or built locally.Read 4 Oct 2026 · pg-odyssey.tech

Support

Users can report issues on the project page or ask usage and development questions in the Telegram community; the project says responses may not be quick.Read 4 Oct 2026 · pg-odyssey.tech

License

The maker's license page permits redistribution and use of source and binary forms, subject to its listed conditions and disclaimer.Read 4 Oct 2026 · pg-odyssey.tech

Administration

Its administration console accepts PostgreSQL client connections and provides administrative commands and metrics or statistics.Read 4 Oct 2026 · pg-odyssey.tech

Authentication

Odyssey supports SSL/TLS, md5 and clear-text authentication, and PAM and LDAP authentication.Read 4 Oct 2026 · pg-odyssey.tech

Authentication and encryption

The documentation describes SSL/TLS support, md5 and clear-text authentication, and PAM and LDAP authentication.Read 4 Oct 2026 · pg-odyssey.tech

Connection pools

Pools can be configured separately for each database and user, including authentication, pooling mode, and limits.Read 4 Oct 2026 · pg-odyssey.tech

Distribution

The project documents Debian and Ubuntu packages from PGDG, public Docker images, Docker builds, and local builds.Read 4 Oct 2026 · pg-odyssey.tech

Exporter maturity

The maker describes the Prometheus exporter as being in development and directs users with problems to contact the project.Read 4 Oct 2026 · pg-odyssey.tech

Load balancing

Odyssey distributes connections or requests among multiple PostgreSQL servers and selects hosts using configured priorities.Read 4 Oct 2026 · pg-odyssey.tech

Maintainer

The documentation credits YANDEX LLC and says it is maintained by the Yandex Cloud MDB team.Read 4 Oct 2026 · pg-odyssey.tech

Monitoring

Odyssey metrics can be exposed in Prometheus format using an exporter that connects to the Odyssey console.Read 4 Oct 2026 · pg-odyssey.tech

Monitoring integration

A Go-based Prometheus exporter connects to the Odyssey console and exposes metrics at a /metrics HTTP endpoint.Read 4 Oct 2026 · pg-odyssey.tech

Online restart

Odyssey supports online restart using two instances so the existing instance serves current connections while the second accepts new ones.Read 4 Oct 2026 · pg-odyssey.tech

Platform limit

The local-build documentation says Odyssey runs only on Linux and supports x86 and x86_64.Read 4 Oct 2026 · pg-odyssey.tech

Platform limitation

The maker says local builds run only on Linux and support x86 and x86_64.Read 4 Oct 2026 · pg-odyssey.tech

Pool configuration

Separate pools can be configured for each database and user pair, with individual authentication, pooling mode and limits.Read 4 Oct 2026 · pg-odyssey.tech

Pooling modes

Odyssey supports session pooling and transaction pooling, with transaction pooling suited to stateless workloads but not preserving session state between transactions.Read 4 Oct 2026 · pg-odyssey.tech

Prepared statements

Prepared statements can be used with transaction pooling when pool_reserve_prepared_statement is enabled.Read 4 Oct 2026 · pg-odyssey.tech

Production use

The maker says Odyssey is production-ready and used in large production setups.Read 4 Oct 2026 · pg-odyssey.tech

Read/write routing

Target session attributes can route connections to PostgreSQL hosts according to read-write or read-only requirements.Read 4 Oct 2026 · pg-odyssey.tech

Replication lag

The catchup timeout feature can drop connections to PostgreSQL hosts whose replication lag exceeds a configured threshold.Read 4 Oct 2026 · pg-odyssey.tech

Version limitation

The quick-start page says only Docker image versions starting with 1.5.0 are supported.Read 4 Oct 2026 · pg-odyssey.tech

Where Specifiction places it

• Database Proxy Software#17 of 317.5