A Helm chart for PgCat a PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring.

A Helm chart for PgCat a PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring.

A Helm chart for PgCat a PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring.

A Helm chart for PgCat a PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring.

A Helm chart for PgCat a PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring.

Potentially Breaking Changes

These changes are not intentionally breaking, but they may cause issues if the user accidentally depends on the old behavior

• Reset instead of discard all by @zainkabani in #549
• QueryRouter: route to primary when locks exists (select for update) by @jgoday in #782

What's Changed

• Add github tag as tag to image by @mpfeil in #537
• pgcat deb package by @levkk in #539
• Add systemd service by @levkk in #540
• Make infer role configurable and fix double parse bug by @zainkabani in #533
• Preserve existing behavior by @levkk in #541
• Revert "Preserve existing behavior" by @levkk in #542
• parse server error messages by @sebastianwebber in #543
• Handle and track startup parameters by @zainkabani in #478
• Add pgcat user by @levkk in #546
• Adds option to log which parameter status is changed by the client by @zainkabani in #550
• docs: complete the missing general items by @Cluas in #553
• chore(deps): bump rustls-webpki from 0.100.1 to 0.100.2 by @dependabot in #555
• Fixes try_execute_command message parsing bug by @zainkabani in #560
• Don't unwrap stream.peer_addr() by @zainkabani in #562
• Add yj to CI image by @drdrsh in #568
• Allow pause/resuming all pools by @tommyzli in #566
• Fix Docker image runs erroring due to glibc incompatability by @hi019 in #572
• stream.peer_addr() & auth_query by @hellower in #575
• Allow configuring routing decision when no shard is selected by @drdrsh in #578
• User-friendly error messages by @levkk in #586
• Revert "User-friendly error messages" by @levkk in #587
• Include thread_id in the logs by @mdashti in #592
• Add a cache layer to Docker by @mdashti in #594
• Report maxwait for clients that end up not getting a connection by @levkk in #596
• Mark admin clients as disconnected on error by @levkk in #597
• Fix incorrect data output for plugin query_logger by @kevinelliott in #601
• Add psql to the container image. by @nicolasvan in #607
• chore(deps): bump webpki from 0.22.0 to 0.22.2 in /tests/rust by @dependabot in #609
• Automatic sharding for INSERT, UPDATE, and DELETE statements. by @mdashti in #610
• Added a Plugin trait by @mdashti in #536
• Added yj to dev Dockerfile by @mdashti in #612
• Added clippy to CI and fixed all clippy warnings by @mdashti in #613
• Removed unnecessary clippy overrides. by @mdashti in #614
• Reduces the amount of time the get_pool operation takes by @zainkabani in #625
• Reimplement prepared statements with LRU cache and statement deduplication by @zainkabani in #618
• bump version by @levkk in #629
• Add connect_timeout and idle_timeout to the user by @levkk in #634
• Update Dockerfile.ci with golang by @sjuls in #637
• Support unnamed prepared statements by @sjuls in #635
• Expose clients maxwait time in SHOW CLIENTS response via admin by @calvinhughes in #639
• Dont cache prepared statement with errors by @levkk in #647
• Fix deb build overwriting config by @levkk in #651
• Broken blog link by @levkk in #652
• Require a reason when marking a server bad by @alecharmon in #654
• only report wait times from clients currently waiting to match behavior of pgbouncer by @dbabiak in #655
• Reset wait times when checked out successfully by @levkk in #656
• Revert max_wait changes by @levkk in #658
• Report waiting time only for currently waiting clients by @drdrsh in #678
• feat: add helm chart by @david972 in #619
• Update sqlparser to 0.41 by @tobyhede in #666
• Use rust:bullseye as base image by @horacio-qogita in #725
• Report checkout error when all servers are down by @drdrsh in #736
• Add TCP_NODELAY option to improve performance for large response queries by @zsand in #749
• Add STOPSIGNAL to Dockerfile by @adriangb in #758
• update rust version in docker image by @adriangb in #762
• Add ExecReload option to pgcat.service for configuration reloads by @dog-64 in #760
• Fix lint warnings for rust-1.79 by @brandonpike in #769
• Fix a Panic in admin commands by @drdrsh in #779
• Fix CI image build step by @drdrsh in #780
• Bump the hyper crate to v1.4.1 and rework prometheus server handling by @sarajmunjal in #778
• Add linux/arm64 docker image build support by @kwongtn in #774

New Contributors

• @mpfeil made their first contribution in #537
• @tommyzli made their first contribution in #566
• @hi019 made their first contribution in #572
• @hellower made their first contribution in #575
• @mdashti made their first contribution in #592
• @kevinelliott made their first contribution in #601
• @nicolasvan made their first contribution in #607
• @sjuls made their first contribution in #637
• @calvinhughes made their first contribution in #639
• @alecharmon made their first contribution in #654
• @dbabiak made their first contribution in #655
• @david972 made their first contribution in #619
• @tobyhede made their first contribution in #666
• @horacio-qogita made their first contribution in #725
• @zsand made their first contribution in #749
• @adriangb made their first contribution in #758
• @dog-64 made their first contribution in #760
• @brandonpike made their first contribution in #769
• @sarajmunjal made their first contribution in #778
• @kwongtn made their first contribution in #774
• @jgoday made their first contribution in #765

Full Changelog: v1.1.1...v1.2.0

A Helm chart for PgCat a PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring.

A Helm chart for PgCat a PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring.

What's Changed

• Fixed performance regression in prepared statements issuing a Flush to Postgres on every iteration of the cache maintenance loop @levkk
• Restore the ability to filter spammy log messages by @Spindel in #530
• Fix typo in the config documentation by @bpaquet in #532

New Contributors

• @Spindel made their first contribution in #530
• @bpaquet made their first contribution in #532

Full Changelog: v1.1.0...v1.1.1

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