v1.1.0

Big Features

• Support for prepared statements
• Auth passthrough for MD5 (Postgres <14)
• Support for server TLS connections

Improvements

• Stats use atomics instead of channels, much faster and more reliable.
• Keep-alives for client connections help with reliability
• Clients and servers don't have to have the same password to connect to Postgres, allowing for password rotations on the server
• Can deploy pooler without connecting to servers
• Better logging using tracing
• LIFO and FIFO options for pool connection handling
• Started the plugins interface with a few example applications
• Stats using atomics instead of channels for better performance and reliability
• Many bug fixes and other improvements

Changelog

• Refactor stats to use atomics by @magec in #375
• Auth passthrough (auth_query) by @magec in #266
• Protocol-level test helpers by @drdrsh in #393
• Fix port; add user pool mode by @levkk in #395
• A couple things by @levkk in #397
• Fix typos by @kianmeng in #398
• Load config on client connect by @levkk in #401
• feat: set keepalive for pgcat server itself by @Cluas in #402
• Separate server and client passwords optionally by @levkk in #407
• Fix CONFIG by @levkk in #408
• README updates by @levkk in #409
• fix typo by @NOBLES5E in #415
• Add more pool settings by @levkk in #416
• Server TLS by @levkk in #417
• Readme update by @levkk in #418
• Add dns_cache for server addresses as in pgbouncer by @magec in #249
• Plugins! by @levkk in #420
• Actually plugins by @levkk in #421
• lowercase config query by @levkk in #422
• Optionally validate config on boot by @levkk in #423
• Accurate log messages by @levkk in #425
• First try with role reset by @atanner27 in #427
• Calculate averages correctly and preserve totals like before by @levkk in #429
• Fix docker-compose dev stack for Apple silicon by @drdrsh in #432
• Fixes average stats bug by @zainkabani in #436
• Improve logging for connection cleanup by @zainkabani in #428
• Prewarmer by @levkk in #435
• Allow to deploy pools without checking by @levkk in #438
• Fix time based average stats by @zainkabani in #442
• Optionally clean up server connections by @levkk in #444
• Ensure data makes it to the client by @levkk in #446
• Refactor Pool Stats to be based off of Server/Client stats by @drdrsh in #445
• Use latest bb8 and use Lifo as the queue strategy in the pool by @zainkabani in #455
• Change default server lifetime and bump bb8 version to use LIFO correctly by @zainkabani in #462
• Make queue strategy configurable and default to Fifo by @zainkabani in #463
• Report min_pool_size correctly by @jchen1 in #471
• Support for prepared statements by @levkk in #474
• Log not implemented messages as debug in prometheus metrics. by @jbub in #477
• fmt by @levkk in #480
• Fix build by @levkk in #481
• Implement Close for prepared statements by @levkk in #482
• Fixes the default for round robing in General by @zainkabani in #488
• [BUG] Fix binding of NULL value parameters in prepared statements by @voldemarich in #496
• docs: fix general.autoreload description by @Cluas in #491
• Add support for tcp_user_timeout by @drdrsh in #503
• add "show help" command by @sebastianwebber in #505
• push and build only in main and tags by @sebastianwebber in #508
• Add cmd line parser by @sebastianwebber in #512
• add support for multiple log formats by @sebastianwebber in #517
• add --no-color option to disable colors in the terminal by @sebastianwebber in #518
• Fix COPY FROM and add tests by @drdrsh in #522
• Release 1.1 by @levkk in #526

New Contributors

• @kianmeng made their first contribution in #398
• @NOBLES5E made their first contribution in #415
• @atanner27 made their first contribution in #427
• @jchen1 made their first contribution in #471
• @jbub made their first contribution in #477
• @voldemarich made their first contribution in #496
• @sebastianwebber made their first contribution in #505

Full Changelog: v1.0.0...v1.1.0