Levkk Pgcat Versions Save

PostgreSQL pooler with sharding, load balancing and failover support.

pgcat-0.1.0

2 months ago

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

v1.1.1

9 months ago

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 https://github.com/postgresml/pgcat/pull/530
Fix typo in the config documentation by @bpaquet in https://github.com/postgresml/pgcat/pull/532

New Contributors

@Spindel made their first contribution in https://github.com/postgresml/pgcat/pull/530
@bpaquet made their first contribution in https://github.com/postgresml/pgcat/pull/532

Full Changelog: https://github.com/postgresml/pgcat/compare/v1.1.0...v1.1.1

v1.1.0

9 months ago

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

New Contributors

@kianmeng made their first contribution in https://github.com/postgresml/pgcat/pull/398
@NOBLES5E made their first contribution in https://github.com/postgresml/pgcat/pull/415
@atanner27 made their first contribution in https://github.com/postgresml/pgcat/pull/427
@jchen1 made their first contribution in https://github.com/postgresml/pgcat/pull/471
@jbub made their first contribution in https://github.com/postgresml/pgcat/pull/477
@voldemarich made their first contribution in https://github.com/postgresml/pgcat/pull/496
@sebastianwebber made their first contribution in https://github.com/postgresml/pgcat/pull/505

Full Changelog: https://github.com/postgresml/pgcat/compare/v1.0.0...v1.1.0

v1.0.0

1 year ago

Announcing v1

After over a year of development, we are proud to announce that we made it to v1! PgCat is stable, running in production and serving hundreds of thousands of queries.

Many thanks and congratulations to our amazing contributors for this effort. A special thank you to @drdrsh for pioneering PgCat at Instacart and implementing many critical features and bug fixes.

What's Changed

A bit faster get_pool by @drdrsh in https://github.com/postgresml/pgcat/pull/187
Use Jemalloc by @drdrsh in https://github.com/postgresml/pgcat/pull/189
Don't send discard all when state is changed in transaction by @zainkabani in https://github.com/postgresml/pgcat/pull/186
Re-enable query parser and parse multiple statements by @levkk in https://github.com/postgresml/pgcat/pull/191
Fix docker-compose by @levkk in https://github.com/postgresml/pgcat/pull/193
Automatic sharding: part one of many by @levkk in https://github.com/postgresml/pgcat/pull/194
Dont change shard unless you know by @levkk in https://github.com/postgresml/pgcat/pull/195
Add dependabot for keeping dependencies up-to-date by @chhetripradeep in https://github.com/postgresml/pgcat/pull/196
chore(deps): bump regex from 1.5.5 to 1.6.0 by @dependabot in https://github.com/postgresml/pgcat/pull/197
chore(deps): bump serde_derive from 1.0.136 to 1.0.147 by @dependabot in https://github.com/postgresml/pgcat/pull/198
chore(deps): bump sha2 from 0.10.2 to 0.10.5 by @dependabot in https://github.com/postgresml/pgcat/pull/199
chore(deps): bump async-trait from 0.1.52 to 0.1.58 by @dependabot in https://github.com/postgresml/pgcat/pull/200
chore(deps): bump bytes from 1.1.0 to 1.2.1 by @dependabot in https://github.com/postgresml/pgcat/pull/206
chore(deps): bump rustls-pemfile from 1.0.0 to 1.0.1 by @dependabot in https://github.com/postgresml/pgcat/pull/205
chore(deps): bump base64 from 0.13.0 to 0.13.1 by @dependabot in https://github.com/postgresml/pgcat/pull/203
chore(deps): bump arc-swap from 1.5.0 to 1.5.1 by @dependabot in https://github.com/postgresml/pgcat/pull/202
chore(deps): bump rand from 0.8.4 to 0.8.5 by @dependabot in https://github.com/postgresml/pgcat/pull/201
chore(deps): bump tokio from 1.16.1 to 1.19.2 by @dependabot in https://github.com/postgresml/pgcat/pull/210
chore(deps): bump once_cell from 1.9.0 to 1.16.0 by @dependabot in https://github.com/postgresml/pgcat/pull/209
chore(deps): bump log from 0.4.14 to 0.4.17 by @dependabot in https://github.com/postgresml/pgcat/pull/216
chore(deps): bump serde from 1.0.136 to 1.0.147 by @dependabot in https://github.com/postgresml/pgcat/pull/215
chore(deps): bump md-5 from 0.10.0 to 0.10.4 by @dependabot in https://github.com/postgresml/pgcat/pull/214
chore(deps): bump sha2 from 0.10.5 to 0.10.6 by @dependabot in https://github.com/postgresml/pgcat/pull/213
chore(deps): bump env_logger from 0.9.0 to 0.9.1 by @dependabot in https://github.com/postgresml/pgcat/pull/212
chore(deps): bump chrono from 0.4.19 to 0.4.22 by @dependabot in https://github.com/postgresml/pgcat/pull/211
chore(deps): bump toml from 0.5.8 to 0.5.9 by @dependabot in https://github.com/postgresml/pgcat/pull/207
Fix for warnings about avg_errors not implemented by @chhetripradeep in https://github.com/postgresml/pgcat/pull/220
Fix dependabot labels for pull-requests by @chhetripradeep in https://github.com/postgresml/pgcat/pull/219
chore(deps): bump jemallocator from 0.3.2 to 0.5.0 by @dependabot in https://github.com/postgresml/pgcat/pull/218
chore(deps): bump md-5 from 0.10.4 to 0.10.5 by @dependabot in https://github.com/postgresml/pgcat/pull/217
chore(deps): bump num_cpus from 1.13.1 to 1.14.0 by @dependabot in https://github.com/postgresml/pgcat/pull/221
chore(deps): bump regex from 1.6.0 to 1.7.0 by @dependabot in https://github.com/postgresml/pgcat/pull/224
chore(deps): bump env_logger from 0.9.1 to 0.9.3 by @dependabot in https://github.com/postgresml/pgcat/pull/223
chore(deps): bump hyper from 0.14.20 to 0.14.23 by @dependabot in https://github.com/postgresml/pgcat/pull/222
chore: make clippy lint happy by @Cluas in https://github.com/postgresml/pgcat/pull/225
chore(deps): bump chrono from 0.4.22 to 0.4.23 by @dependabot in https://github.com/postgresml/pgcat/pull/230
chore(deps): bump sqlparser from 0.26.0 to 0.27.0 by @dependabot in https://github.com/postgresml/pgcat/pull/229
Default to using username when database isn't present on startup by @zainkabani in https://github.com/postgresml/pgcat/pull/234
Adds health check setting to pool and avoids get_config in hotpath by @zainkabani in https://github.com/postgresml/pgcat/pull/235
Adds configuration for logging connections and removes get_config from entrypoint by @zainkabani in https://github.com/postgresml/pgcat/pull/236
Move ClientBadStartup error log to debug by @zainkabani in https://github.com/postgresml/pgcat/pull/237
Move get_config in startup to admin branch to scope down usage by @zainkabani in https://github.com/postgresml/pgcat/pull/238
Adds details to errors and fixes error propagation bug by @zainkabani in https://github.com/postgresml/pgcat/pull/239
chore(deps): bump bytes from 1.2.1 to 1.3.0 by @dependabot in https://github.com/postgresml/pgcat/pull/240
chore(deps): bump env_logger from 0.9.3 to 0.10.0 by @dependabot in https://github.com/postgresml/pgcat/pull/241
chore(deps): bump serde from 1.0.147 to 1.0.148 by @dependabot in https://github.com/postgresml/pgcat/pull/242
chore(deps): bump serde_derive from 1.0.147 to 1.0.148 by @dependabot in https://github.com/postgresml/pgcat/pull/243
chore(deps): bump sha-1 from 0.10.0 to 0.10.1 by @dependabot in https://github.com/postgresml/pgcat/pull/244
chore(deps): bump async-trait from 0.1.58 to 0.1.59 by @dependabot in https://github.com/postgresml/pgcat/pull/245
chore(deps): bump sqlparser from 0.27.0 to 0.28.0 by @dependabot in https://github.com/postgresml/pgcat/pull/248
chore(deps): bump serde_derive from 1.0.148 to 1.0.149 by @dependabot in https://github.com/postgresml/pgcat/pull/247
chore(deps): bump serde from 1.0.148 to 1.0.149 by @dependabot in https://github.com/postgresml/pgcat/pull/246
chore(deps): bump base64 from 0.13.1 to 0.20.0 by @dependabot in https://github.com/postgresml/pgcat/pull/250
chore(deps): bump serde_derive from 1.0.149 to 1.0.150 by @dependabot in https://github.com/postgresml/pgcat/pull/251
chore(deps): bump serde from 1.0.149 to 1.0.150 by @dependabot in https://github.com/postgresml/pgcat/pull/252
chore(deps): bump toml from 0.5.9 to 0.5.10 by @dependabot in https://github.com/postgresml/pgcat/pull/256
Allow setting idle_timeout for server connections. by @magec in https://github.com/postgresml/pgcat/pull/257
Allow setting the number of runtime workers to be used. by @magec in https://github.com/postgresml/pgcat/pull/258
chore(deps): bump serde from 1.0.150 to 1.0.151 by @dependabot in https://github.com/postgresml/pgcat/pull/260
chore(deps): bump async-trait from 0.1.59 to 0.1.60 by @dependabot in https://github.com/postgresml/pgcat/pull/259
chore(deps): bump serde_derive from 1.0.150 to 1.0.151 by @dependabot in https://github.com/postgresml/pgcat/pull/261
chore(deps): bump num_cpus from 1.14.0 to 1.15.0 by @dependabot in https://github.com/postgresml/pgcat/pull/264
Buffer copy data messages by @zainkabani in https://github.com/postgresml/pgcat/pull/265
Remove logo, pending new logo by @levkk in https://github.com/postgresml/pgcat/pull/267
Fix typo in README by @eoinkelly in https://github.com/postgresml/pgcat/pull/272
chore(deps): bump arc-swap from 1.5.1 to 1.6.0 by @dependabot in https://github.com/postgresml/pgcat/pull/273
Fix tests (use sudo) by @levkk in https://github.com/postgresml/pgcat/pull/276
chore(deps): bump sqlparser from 0.28.0 to 0.30.0 by @dependabot in https://github.com/postgresml/pgcat/pull/275
chore(deps): bump once_cell from 1.16.0 to 1.17.0 by @dependabot in https://github.com/postgresml/pgcat/pull/270
chore(deps): bump serde_derive from 1.0.151 to 1.0.152 by @dependabot in https://github.com/postgresml/pgcat/pull/269
chore(deps): bump serde from 1.0.151 to 1.0.152 by @dependabot in https://github.com/postgresml/pgcat/pull/268
chore(deps): bump async-trait from 0.1.60 to 0.1.61 by @dependabot in https://github.com/postgresml/pgcat/pull/278
chore(deps): bump base64 from 0.20.0 to 0.21.0 by @dependabot in https://github.com/postgresml/pgcat/pull/279
chore(deps): bump regex from 1.7.0 to 1.7.1 by @dependabot in https://github.com/postgresml/pgcat/pull/280
Update cargo lock file by @zainkabani in https://github.com/postgresml/pgcat/pull/281
Write messages directly onto message buffer instead of allocating on own buffer by @zainkabani in https://github.com/postgresml/pgcat/pull/283
Introduce least-outstanding-connections load balancing by @drdrsh in https://github.com/postgresml/pgcat/pull/282
Buffer client CopyData messages by @zainkabani in https://github.com/postgresml/pgcat/pull/284
chore(deps): bump tokio from 1.24.1 to 1.24.2 by @dependabot in https://github.com/postgresml/pgcat/pull/286
chore(deps): bump activerecord from 7.0.3.1 to 7.0.4.1 in /tests/ruby by @dependabot in https://github.com/postgresml/pgcat/pull/287
Log error messages for network failures by @drdrsh in https://github.com/postgresml/pgcat/pull/289
Removes message cloning operation required for query router by @zainkabani in https://github.com/postgresml/pgcat/pull/285
Add more metrics to prometheus endpoint by @magec in https://github.com/postgresml/pgcat/pull/263
Refactors is_banned logic and forces health check on unban by @zainkabani in https://github.com/postgresml/pgcat/pull/288
chore(deps): bump toml from 0.5.10 to 0.5.11 by @dependabot in https://github.com/postgresml/pgcat/pull/290
chore(deps): bump async-trait from 0.1.61 to 0.1.63 by @dependabot in https://github.com/postgresml/pgcat/pull/291
chore(deps): bump toml from 0.5.11 to 0.6.0 by @dependabot in https://github.com/postgresml/pgcat/pull/292
Fix formatting by @levkk in https://github.com/postgresml/pgcat/pull/299
Startup improvements & PAUSE/RESUME by @levkk in https://github.com/postgresml/pgcat/pull/300
Add initial Windows support, ref #298 by @Kurtsley in https://github.com/postgresml/pgcat/pull/301
chore(deps): bump tokio from 1.24.2 to 1.25.0 by @dependabot in https://github.com/postgresml/pgcat/pull/304
chore(deps): bump toml from 0.6.0 to 0.7.0 by @dependabot in https://github.com/postgresml/pgcat/pull/305
chore(deps): bump bytes from 1.3.0 to 1.4.0 by @dependabot in https://github.com/postgresml/pgcat/pull/310
chore(deps): bump hyper from 0.14.23 to 0.14.24 by @dependabot in https://github.com/postgresml/pgcat/pull/311
chore(deps): bump toml from 0.7.0 to 0.7.1 by @dependabot in https://github.com/postgresml/pgcat/pull/309
chore(deps): bump futures from 0.3.25 to 0.3.26 by @dependabot in https://github.com/postgresml/pgcat/pull/307
chore(deps): bump async-trait from 0.1.63 to 0.1.64 by @dependabot in https://github.com/postgresml/pgcat/pull/308
Fix logging mistakes by @zainkabani in https://github.com/postgresml/pgcat/pull/313
Introduce tcp_keepalives to PgCat by @drdrsh in https://github.com/postgresml/pgcat/pull/315
Fix code coverage + less flakiness by @drdrsh in https://github.com/postgresml/pgcat/pull/318
Support EC and PKCS8 private keys by @tommy351 in https://github.com/postgresml/pgcat/pull/316
Fix deprecation warnings by @drdrsh in https://github.com/postgresml/pgcat/pull/319
chore(deps): bump once_cell from 1.17.0 to 1.17.1 by @dependabot in https://github.com/postgresml/pgcat/pull/320
Allow shard setting with comments by @jmeagher in https://github.com/postgresml/pgcat/pull/293
Log worker thread count by @zainkabani in https://github.com/postgresml/pgcat/pull/322
Bake toxiproxy in CI image by @drdrsh in https://github.com/postgresml/pgcat/pull/323
Build Dockerfile.ci using Github workflows by @drdrsh in https://github.com/postgresml/pgcat/pull/325
Move toxiproxy.deb to /tmp by @drdrsh in https://github.com/postgresml/pgcat/pull/326
Add psmisc to CI image by @drdrsh in https://github.com/postgresml/pgcat/pull/327
More Test coverage + fix some code coverage bugs by @drdrsh in https://github.com/postgresml/pgcat/pull/321
More coverage cleanup by @drdrsh in https://github.com/postgresml/pgcat/pull/328
implement show users by @dat2 in https://github.com/postgresml/pgcat/pull/329
Fix Back-and-forth RELOAD Bug by @drdrsh in https://github.com/postgresml/pgcat/pull/330
Adds SHUTDOWN command as alternate option to sending SIGINT by @zainkabani in https://github.com/postgresml/pgcat/pull/331
Allow sending logs to stdout by using STDOUT_LOG env var by @magec in https://github.com/postgresml/pgcat/pull/334
chore(deps): bump sqlparser from 0.30.0 to 0.31.0 by @dependabot in https://github.com/postgresml/pgcat/pull/335
chore(deps): bump tokio from 1.25.0 to 1.26.0 by @dependabot in https://github.com/postgresml/pgcat/pull/336
Automatic sharding for SELECT v2 by @levkk in https://github.com/postgresml/pgcat/pull/337
Dev environment by @magec in https://github.com/postgresml/pgcat/pull/338
Add Manual host banning to PgCat by @drdrsh in https://github.com/postgresml/pgcat/pull/340
chore(deps): bump async-trait from 0.1.64 to 0.1.66 by @dependabot in https://github.com/postgresml/pgcat/pull/342
chore(deps): bump sqlparser from 0.31.0 to 0.32.0 by @dependabot in https://github.com/postgresml/pgcat/pull/343
chore(deps): bump serde from 1.0.152 to 1.0.154 by @dependabot in https://github.com/postgresml/pgcat/pull/348
chore(deps): bump serde_derive from 1.0.152 to 1.0.154 by @dependabot in https://github.com/postgresml/pgcat/pull/347
PgCat Query Mirroring by @drdrsh in https://github.com/postgresml/pgcat/pull/341
Reorder fields in Shard to avoid ValueAfterTable errors by @drdrsh in https://github.com/postgresml/pgcat/pull/349
Extended query protocol sharding by @levkk in https://github.com/postgresml/pgcat/pull/339
Build on 1.67 by @levkk in https://github.com/postgresml/pgcat/pull/350
Improve Config Documentation by @drdrsh in https://github.com/postgresml/pgcat/pull/351
Update README.md by @drdrsh in https://github.com/postgresml/pgcat/pull/352
Update CONFIG.md by @drdrsh in https://github.com/postgresml/pgcat/pull/353
Reduce memory and CPU footprint of mirroring by @drdrsh in https://github.com/postgresml/pgcat/pull/369
github/workflows: adds automated image building by @Fraser-Isbester in https://github.com/postgresml/pgcat/pull/370
Check Slice bounds in read_message to avoid panics by @drdrsh in https://github.com/postgresml/pgcat/pull/371
Add idle client in transaction configuration by @zainkabani in https://github.com/postgresml/pgcat/pull/380
V1 by @levkk in https://github.com/postgresml/pgcat/pull/383
Contributors by @levkk in https://github.com/postgresml/pgcat/pull/384

New Contributors

@Cluas made their first contribution in https://github.com/postgresml/pgcat/pull/225
@magec made their first contribution in https://github.com/postgresml/pgcat/pull/257
@eoinkelly made their first contribution in https://github.com/postgresml/pgcat/pull/272
@Kurtsley made their first contribution in https://github.com/postgresml/pgcat/pull/301
@tommy351 made their first contribution in https://github.com/postgresml/pgcat/pull/316
@jmeagher made their first contribution in https://github.com/postgresml/pgcat/pull/293
@Fraser-Isbester made their first contribution in https://github.com/postgresml/pgcat/pull/370

Full Changelog: https://github.com/postgresml/pgcat/compare/v0.3.0...v1.0.0

v0.3.0

1 year ago

Summary

Lots of bug fixes and optimizations.

What's Changed

Live reloading entire config and bug fixes by @levkk in https://github.com/levkk/pgcat/pull/84
Fix panic & query router bug by @levkk in https://github.com/levkk/pgcat/pull/85
Automatically reload config every seconds (disabled by default) by @levkk in https://github.com/levkk/pgcat/pull/86
Fix stats dymanic reload by @levkk in https://github.com/levkk/pgcat/pull/87
Support for TLS by @levkk in https://github.com/levkk/pgcat/pull/91
Bump activerecord from 7.0.2.2 to 7.0.3.1 in /tests/ruby by @dependabot in https://github.com/levkk/pgcat/pull/94
Add support for multi-database / multi-user pools by @drdrsh in https://github.com/levkk/pgcat/pull/96
Minor fix for some stats by @chhetripradeep in https://github.com/levkk/pgcat/pull/97
Add Serialize trait to configs by @drdrsh in https://github.com/levkk/pgcat/pull/99
Slightly more light weight health check by @drdrsh in https://github.com/levkk/pgcat/pull/100
Avoid ValueAfterTable when serializing configs by @drdrsh in https://github.com/levkk/pgcat/pull/101
Add test for config Serializer by @drdrsh in https://github.com/levkk/pgcat/pull/102
Send proper server parameters to clients using admin db by @drdrsh in https://github.com/levkk/pgcat/pull/103
Sync pgcat config for docker-compose by @chhetripradeep in https://github.com/levkk/pgcat/pull/104
Fix Python tests and remove CircleCI-specific path by @drdrsh in https://github.com/levkk/pgcat/pull/106
Add user to SHOW STATS query by @drdrsh in https://github.com/levkk/pgcat/pull/108
Report banned addresses as disabled by @drdrsh in https://github.com/levkk/pgcat/pull/111
Generate test coverage report in CircleCI by @drdrsh in https://github.com/levkk/pgcat/pull/110
Fix local dev by @drdrsh in https://github.com/levkk/pgcat/pull/112
Implementing graceful shutdown by @zainkabani in https://github.com/levkk/pgcat/pull/105
Prevent clients from sticking to old pools after config update by @drdrsh in https://github.com/levkk/pgcat/pull/113
create a prometheus exporter on a standard http port by @dat2 in https://github.com/levkk/pgcat/pull/107
Validates pgcat is closed after shutdown python tests by @zainkabani in https://github.com/levkk/pgcat/pull/116
fix docker compose port allocation for local dev by @dat2 in https://github.com/levkk/pgcat/pull/117
Health check delay by @zainkabani in https://github.com/levkk/pgcat/pull/118
Speed up CI a bit by @levkk in https://github.com/levkk/pgcat/pull/119
Fix debug log by @levkk in https://github.com/levkk/pgcat/pull/120
Make prometheus port configurable by @chhetripradeep in https://github.com/levkk/pgcat/pull/121
Statement timeout + replica imbalance by @levkk in https://github.com/levkk/pgcat/pull/122
Add cl_idle to SHOW POOLS by @drdrsh in https://github.com/levkk/pgcat/pull/124
Fix missing statistics by @levkk in https://github.com/levkk/pgcat/pull/125
Minor cleanup in admin command by @chhetripradeep in https://github.com/levkk/pgcat/pull/126
Add pool name and username to address object by @drdrsh in https://github.com/levkk/pgcat/pull/128
Minor Refactoring of re-used code and server stat reporting by @zainkabani in https://github.com/levkk/pgcat/pull/129
Random instance selection by @drdrsh in https://github.com/levkk/pgcat/pull/136
Random lb by @levkk in https://github.com/levkk/pgcat/pull/138
Fix incorrect routing for replicas by @levkk in https://github.com/levkk/pgcat/pull/139
Fix too many idle servers by @levkk in https://github.com/levkk/pgcat/pull/140
Really fix idle servers by @levkk in https://github.com/levkk/pgcat/pull/141
Avoid sending Z packet in the middle of extended protocol packet sequence if we fail to get connection form pool by @drdrsh in https://github.com/levkk/pgcat/pull/137
Graceful shutdown and refactor by @levkk in https://github.com/levkk/pgcat/pull/144
Exit with failure codes if configs are bad by @drdrsh in https://github.com/levkk/pgcat/pull/146
Move autoreloader to own tokio task by @zainkabani in https://github.com/levkk/pgcat/pull/148
Ruby integration tests by @drdrsh in https://github.com/levkk/pgcat/pull/147
Allow running integration tests with coverage locally by @drdrsh in https://github.com/levkk/pgcat/pull/151
Log Address information in connection create/drop by @drdrsh in https://github.com/levkk/pgcat/pull/154
Better handling extended protocol messages in the event of busy pool by @drdrsh in https://github.com/levkk/pgcat/pull/155
Send DISCARD ALL even if client is not in transaction by @drdrsh in https://github.com/levkk/pgcat/pull/152
Patch graceful shutdown bug by @zain-kabani in https://github.com/levkk/pgcat/pull/157
Main Thread Panic when swarmed with clients by @drdrsh in https://github.com/levkk/pgcat/pull/158
Adds microsecond logging and also reformats duration to include milliseconds by @zainkabani in https://github.com/levkk/pgcat/pull/156
Avoid reporting ProtocolSyncError when admin session disconnects by @drdrsh in https://github.com/levkk/pgcat/pull/160
Better logging for failure to get connection from pool by @drdrsh in https://github.com/levkk/pgcat/pull/161
Send signal even if process is gone by @levkk in https://github.com/levkk/pgcat/pull/162
Clean connection state up after protocol named prepared statement by @drdrsh in https://github.com/levkk/pgcat/pull/163
Add Discord link by @levkk in https://github.com/levkk/pgcat/pull/164
Add SHOW CLIENTS / SHOW SERVERS + Stats refactor and tests by @drdrsh in https://github.com/levkk/pgcat/pull/159
Report Query times by @drdrsh in https://github.com/levkk/pgcat/pull/166
Export pgcat objects in lib by @zainkabani in https://github.com/levkk/pgcat/pull/169
Update to latest library versions by @zainkabani in https://github.com/levkk/pgcat/pull/170
Minor refactor for configs by @zainkabani in https://github.com/levkk/pgcat/pull/172
Add defaults for configs by @zainkabani in https://github.com/levkk/pgcat/pull/174
Log failed client logins by @drdrsh in https://github.com/levkk/pgcat/pull/173
Don't drop connections if DB hasn't changed by @levkk in https://github.com/levkk/pgcat/pull/175
Fix the pool fix by @levkk in https://github.com/levkk/pgcat/pull/176
Set client state to idle after error by @drdrsh in https://github.com/levkk/pgcat/pull/179
Change sharding config to enum and move validation of configs into public functions by @zainkabani in https://github.com/levkk/pgcat/pull/178
Replace a few types with more developer-friendly names by @levkk in https://github.com/levkk/pgcat/pull/182
Fix maxwait metric by @drdrsh in https://github.com/levkk/pgcat/pull/183

New Contributors

@drdrsh made their first contribution in https://github.com/levkk/pgcat/pull/96
@chhetripradeep made their first contribution in https://github.com/levkk/pgcat/pull/97
@dat2 made their first contribution in https://github.com/levkk/pgcat/pull/107
@zain-kabani made their first contribution in https://github.com/levkk/pgcat/pull/157

Full Changelog: https://github.com/levkk/pgcat/compare/v0.2.1-beta1...v0.3.0

v0.2.1-beta1

1 year ago

Clients are now required to authenticate with MD5.

v0.2.0-beta1

1 year ago

Implemented SCRAM-SHA-256 authentication made compulsory in Postgres 14. This is for PgCat --> server authentication only.

v0.1.0-beta3

1 year ago

Plugged a memory leak in client -> server mapping used for query cancellation that happened with clients that disconnected mid-transaction.

v0.1.0-beta2

2 years ago

Fix for rolling back (resetting) servers that were left idle in transaction by clients that disconnected mid-transaction.

v0.1.0-beta

2 years ago

This is a beta release. The feature set is mature enough that it can be used in low risk environments, dev, staging, pre-prod and low traffic production.

The admin database supports monitoring with Datadog.