We are excited to announce a new release of the Odyssey — advanced multi-threaded connection pooler for PostgreSQL and Apache Cloudberry.

We’ve been hard at work fixing numerous issues and making Odyssey more stable and reliable. Many long-standing problems have now been resolved, and we’ve also introduced several new features.

Features

• Add support for HBA config file and HBA reload logic #442
• Channel binding for SCRAM authentication method #490
• pool_discard_query option #488
• Auto-generated default internal pool if none specified (for auth_query and other internal queries) #519
• Option for strict sequential route matching #605
• Support for aarch64 in machinarium context switch function #446
• Show version number in initial message #670
• Show SHOW HELP; command #669

Bug Fixes

• Fix auth_query password caching leading to SIGSEGV #536
• Fix UNIX socket connection to server with target_session_attrs #499
• Prevent SIGSEGV on usage printing #498
• Many more bug fixes and memory leaks (see the full change log on the release page for details)

Improvements & Refactoring

• Target session attribute for storage #456
• Introduced server connection timeout #750
• Asynchronous logging #722
• Configure mandatory startup parameters for server connections #491
• Various optimizations for transaction pool prepared statement feature #581
• Properly count COPY protocol messages #503

Complete list of changes is on the release page

Thank you for your support and feedback!