Big Features
- Support for prepared statements
- Auth passthrough for MD5 (Postgres <14)
- Support for server TLS connections
Improvements
- Stats use atomics instead of channels, must 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-coloroption 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