Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Odyssey

pg-odyssey.tech

  • Free plan
  • macOS
  • Linux
  • Self-hosted
7.3 Club score Visit pg-odyssey.tech

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.