Odyssey
pg-odyssey.tech
- Free plan
- macOS
- Linux
- Self-hosted
What Odyssey is
Odyssey is an open-source, self-hosted PostgreSQL connection pooler and request router built for multithreaded operation. It supports session pooling and transaction pooling; transaction mode suits stateless workloads but does not preserve session state between transactions. Prepared statements work in transaction mode when `pool_reserve_prepared_statement` is enabled. Administrators can define separate pools for each database and user, with individual authentication, pooling mode, and limits. Odyssey distributes connections or requests across PostgreSQL servers using configured priorities. Target session attributes route read-write or read-only connections, while catchup timeouts can drop hosts whose replication lag exceeds a threshold. Its console accepts PostgreSQL client connections and provides administration commands and metrics. Authentication options include SSL/TLS, md5, clear text, PAM, and LDAP. Deployment uses PGDG packages, public Docker images, or local builds. Online restart uses two instances to keep current connections serving during replacement.
Who it suits
Odyssey suits teams running self-hosted PostgreSQL deployments that need pooling, routing, authentication controls, and replication-lag handling. It is intended for Linux-based server environments.
Good to know, and what to watch
- Session and transaction pooling modes
- Per-database and per-user pool settings
- Read-write and read-only routing
- Replication-lag catchup timeout
- Online restart support
- Local builds run only on Linux
- Supports PostgreSQL only
- Prometheus exporter is still in development
- Docker quick-start requires version 1.5.0 or later
The verdict
Odyssey combines PostgreSQL pooling, routing, authentication, and operational controls for self-hosted infrastructure. Its Linux build restriction and developing exporter matter when planning deployment and monitoring.
What the maker publishes
- Administration
- Its administration console accepts PostgreSQL client connections and provides administrative commands and metrics or statistics. source
- Authentication
- Odyssey supports SSL/TLS, md5 and clear-text authentication, and PAM and LDAP authentication. source
- Authentication and encryption
- The documentation describes SSL/TLS support, md5 and clear-text authentication, and PAM and LDAP authentication. source
- Connection pools
- Pools can be configured separately for each database and user, including authentication, pooling mode, and limits. source
- Deployment
- Odyssey can be installed from the PGDG repository, run from a public Docker image, or built locally. source
- Distribution
- The project documents Debian and Ubuntu packages from PGDG, public Docker images, Docker builds, and local builds. source
- Exporter maturity
- The maker describes the Prometheus exporter as being in development and directs users with problems to contact the project. source
- License
- The maker's license page permits redistribution and use of source and binary forms, subject to its listed conditions and disclaimer. source
- Load balancing
- Odyssey distributes connections or requests among multiple PostgreSQL servers and selects hosts using configured priorities. source
- Maintainer
- The documentation credits YANDEX LLC and says it is maintained by the Yandex Cloud MDB team. source
- Monitoring
- Odyssey metrics can be exposed in Prometheus format using an exporter that connects to the Odyssey console. source
- Monitoring integration
- A Go-based Prometheus exporter connects to the Odyssey console and exposes metrics at a /metrics HTTP endpoint. source
- Online restart
- Odyssey supports online restart using two instances so the existing instance serves current connections while the second accepts new ones. source
- Platform limit
- The local-build documentation says Odyssey runs only on Linux and supports x86 and x86_64. source
- Platform limitation
- The maker says local builds run only on Linux and support x86 and x86_64. source
- Pool configuration
- Separate pools can be configured for each database and user pair, with individual authentication, pooling mode and limits. source
- Pooling modes
- Odyssey supports session pooling and transaction pooling, with transaction pooling suited to stateless workloads but not preserving session state between transactions. source
- Prepared statements
- Prepared statements can be used with transaction pooling when pool_reserve_prepared_statement is enabled. source
- Production use
- The maker says Odyssey is production-ready and used in large production setups. source
- Purpose
- Odyssey is an advanced, multithreaded PostgreSQL connection pooler and request router. source
- Read/write routing
- Target session attributes can route connections to PostgreSQL hosts according to read-write or read-only requirements. source
- Replication lag
- The catchup timeout feature can drop connections to PostgreSQL hosts whose replication lag exceeds a configured threshold. source
- 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. source
- Version limitation
- The quick-start page says only Docker image versions starting with 1.5.0 are supported. source
Checked against the maker's pages on 4 Oct 2026.