v1.1.45

What's Changed

• chore: update runtime.exs path in hot_upgrade by @abc3 in #322

Full Changelog: v1.1.44...v1.1.45

v1.1.44

What's Changed

• fix: set Logger level otherwise Phoenix plug exceptions are not thrown by @chasers in #312
• fix: async calls for all ready_for_query messages by @abc3 in #318
• fix: stop pool connection if credentials fail by @abc3 in #321

Full Changelog: v1.1.40...v1.1.44

v1.1.40

What's Changed

• fix: sync sending after reaching the threshold by @abc3 in #313

Full Changelog: v1.1.39...v1.1.40

v1.1.39

What's Changed

• fix: enable connection to custom database name other than 'postgres' by @w3b6x9 in #254
• fix: tenant id handling in manager by @abc3 in #271
• feat: add new metrics by @abc3 in #270
• feat: pick node to spin up a pool by tenant id by @abc3 in #269
• fix: metrics tenant by @abc3 in #272
• fix: start_dist in client_handler by @abc3 in #275
• fix: kill the linked handler in session mode by @abc3 in #277
• feat: add more logs by @abc3 in #278
• chore: set max heap size for handlers by @abc3 in #280
• fix: setting a mode on transaction port by @abc3 in #283
• feat: setting log level per tenant via options by @abc3 in #286
• feat: update hostname by @abc3 in #288
• chore(deps): bump shlex from 1.2.0 to 1.3.0 in /native/pgparser by @dependabot in #281
• chore: improve logging by @abc3 in #292
• chore: set number of ets tables and processes by @abc3 in #293
• fix: add [active: once] on receiving a response by @abc3 in #295
• feat: reset the check timer after the client's disconnection by @abc3 in #291
• fix: handle client termination in db handler by @abc3 in #296
• fix: add an error case for get_payload() by @abc3 in #297
• fix: stop db handler before client by @abc3 in #298
• feat: local or remote pool checkout duration metric by @abc3 in #299
• feat: recheck auth secrets on connection error by @abc3 in #304
• feat: idle workers in pool by @abc3 in #285
• chore: ecto pool_size 25 by @abc3 in #305
• chore: update options for the get secrets by @abc3 in #306
• feat: clear tenant's cache on update or delete by @abc3 in #309

New Contributors

• @w3b6x9 made their first contribution in #254

Full Changelog: v1.1.13...v1.1.39

v1.1.13

Notable

• Fixes "expected SASL response, got message type" which can appear in Postgres logs
• Don't attempt to check database availability during tenant CRUD operations
• Fixes metrics per tenant endpoint
• Fixes edge cases during scram auth

What's Changed

• feat: track duration from tcp connection to greeting clients by @abc3 in #258
• fix: don't block the connection during the scram dance by @abc3 in #256
• fix: add a new line in tenant metrics by @abc3 in #261
• fix: new line in tenant metrics by @abc3 in #262
• feat: bump Rustler and pg_query to resolve security warning by @J0 in #255
• fix: add proto guards by @abc3 in #267
• feat: don't check db creds on update by @abc3 in #265

Full Changelog: v1.1.6...v1.1.13

v1.1.6

Notable

• Fixes a bug which caused prepared statements to fail in session mode

What's Changed

• fix: linking db pid in session mode by @abc3 in #249

Full Changelog: v1.1.5...v1.1.6

v1.1.5

Notable

• Pools now start with only 10 connections and create new ones up to tenant default_pool_size or user pool_size
• Logs correct tenant id
• API endpoints accept PATCH requests

What's Changed

• fix: DbHandler Logger metadata by @abc3 in #245
• fix: update api by @abc3 in #247
• feat: set initial pool size to 10, enable other via max_overflow by @abc3 in #225

Full Changelog: v1.1.2...v1.1.5

v1.1.2

Notable

• allow_list field on the tenant to support network restrictions
• More docs
• client_heartbeat_interval on the tenant to detect zombie client connections
• Bug fixes
• Observability improvements

What's Changed

• feat: reduce logging by @J0 in #216
• Update pgbouncer.md (fix typo) by @zorbash in #224
• fix: return proper error on undefined tenant by @J0 in #220
• chore(deps): bump rustix from 0.38.10 to 0.38.28 in /native/pgparser by @dependabot in #217
• chore: upgrade gh runner by @abc3 in #226
• feat: add heartbeat interval to client handler by @abc3 in #223
• fix: remove stub in heartbeat_interval by @abc3 in #229
• fix: catch errors from decode_payload by @abc3 in #231
• feat: update the Dockerfile and install Rust so build goes through by @J0 in #237
• fix: higher res buckets for pool checkout duration metric by @chasers in #241
• fix: config compile_time_purge_matching for prod by @chasers in #242
• feat: check ip against allow list by @chasers in #240
• fix: adds a FAQ by @chasers in #235
• chore(deps): bump tj-actions/changed-files from 35 to 41 in /.github/workflows by @dependabot in #243
• feat: update dockerfile and add docker-compose file by @J0 in #215
• feat: add additional clause for Telem.client_join by @J0 in #219

New Contributors

• @dependabot made their first contribution in #217

Full Changelog: v1.0.0...v1.1.2

v1.0.0

Notable

• Added support for named prepared statements
• Added support for read replicas and query load balancing
• Added a client_idle_timeout option
• New docs build process and website (Github hosted)
• Docs for migrating from PgBouncer
• auth_query with md5 support
• native pool_mode to proxy direct connections to Postgres
• New metric for unique connected tenants
• Cache metadata database queries for faster tenant info lookups
• Bug fixes

What's Changed

• feat: added a metric for the number of connected tenants by @abc3 in #154
• fix: scram channel binding by @abc3 in #157
• fix: the total count of connected clients for a tenant by @abc3 in #155
• fix: display 0 in the supavisor_connections field after the last disconnection by @abc3 in #158
• feat: add a mode type to the pool id by @abc3 in #160
• chore: publish a tarball to prod by @abc3 in #161
• feat: add client_idle_timeout option by @abc3 in #165
• chore: update GH actions dependencies by @delgado3d in #166
• chore: bump ecto_sql and logflare_logger_backend by @abc3 in #170
• feat: add an option to set the pool's strategy, default is fifo by @abc3 in #173
• feat: support auth_query with md5 by @abc3 in #175
• fix: error message during md5 auth by @abc3 in #177
• fix: cache for user query, server_name_indication, change log level by @abc3 in #179
• fix: add sni in get_secrets by @abc3 in #181
• fix: host in db_handler is already a charlist by @abc3 in #182
• chore: move docs to mkdocs by @chasers in #186
• docs: auto publish docs on main by @chasers in #189
• fix: install mkdocs-material by @chasers in #192
• docs: more docs by @chasers in #190
• feat: add gh workflow by @J0 in #180
• feat: add native mode by @abc3 in #188
• fix: handle http request in the native mode by @abc3 in #193
• feat: handle cancelling requests by @abc3 in #194
• fix: prevent client <-> db locking by @abc3 in #195
• fix: update doc links by @abc3 in #198
• fix: docs set defaults on tenant for example by @chasers in #199
• fix: docs enumerate tenant and user configs with auth_query by @chasers in #201
• feat: add metrics for connection success/failure and improve error handling by @abc3 in #200
• fix: add docs for migrating from pgbouncer by @chasers in #205
• chore: change from native mode to session mode by @abc3 in #210
• feat: handling of named prepared statements by @abc3 #207
• feat: add support for read replicas by @abc3 in #162

New Contributors

• @delgado3d made their first contribution in #166

Full Changelog: v0.9.0...v1.0.0

v0.9.0

Notable

• SSL support upstream and downstream - clients can connect with SSL and SCRAM-SHA-256 authentication
• Optionally enforce SSL connections - set enforce_ssl to true on the tenant to force clients to connect with SSL
• Authentication query support like PgBouncer - define an auth_query on the tenant to authenticate users dynamically
• Metrics endpoint per tenant - /metrics/:external_id will respond with metrics filtered for a single tenant by external_id
• Region and instance id metadata in logs - filter your logs easily by region or instance_id
• Optionally limit client connections per tenant - set default_max_clients on the tenant and optionally max_clients on the user to limit inbound connections per tenant

What's Changed

• docs(openapi): match tenant update implementation by @ChristianAlexander in #65
• New logo 🔥 by @chasers in #71
• Implement multiple pools per tenant by @abc3 in #73
• fix the 'list tenants' endpoint by @abc3 in #84
• Implement session mode functionality by @abc3 in #79
• Implement Websocket proxy by @abc3 in #82
• feat: handle MD5 authentication by @altjohndev in #89
• feat: add version check to CI via VERSION file by @J0 in #78
• Add logflare support by @abc3 in #96
• Systemd service by @abc3 in #95
• Handle http request by @abc3 in #98
• Add prefix to migration AddTimeoutToUsers by @acco in #99
• Add credo config by @abc3 in #108
• Prevent linking to the db process on startup when transaction mode by @abc3 in #107
• Check creds before adding to db and wait timeout for cold start by @abc3 in #101
• Add Postgres strategy for libcluster by @abc3 in #110
• chore: set min/max values for inet_dist_listen by @abc3 in #113
• Add connection pool stop on db credential change by @abc3 in #114
• chore: add prefix to osmon metrics by @abc3 in #117
• chore: support ipv4 and ipv6 for tenant's db by @abc3 in #115
• fix: pg version without platform by @abc3 in #118
• feat: add mix tasks for generating release artifacts by @abc3 in #119
• SSL support for upstream connections by @abc3 in #124
• SSL support for downstream connections by @abc3 in #129
• Option to allow only SSL connection by @abc3 in #130
• feat: auth_query support by @abc3 in #132
• fix: start proxy on two ports by @abc3 in #136
• fix: update the query for retrieving user creds by @abc3 in #137
• fix: use username from the connection in process names by @abc3 in #141
• feat: add region and instance id to logger by @abc3 in #142
• feat: limit client connections by @abc3 in #144
• feat: api endpoint to terminate tenancy tree connection by @abc3 in #145
• fix: query count and network usage metrics by @abc3 in #149
• feat: metric endpoint per tenant by @abc3 in #147

New Contributors

• @kiwicopple made their first contribution in #53
• @MildTomato made their first contribution in #62
• @zorbash made their first contribution in #64
• @ChristianAlexander made their first contribution in #66
• @altjohndev made their first contribution in #89
• @J0 made their first contribution in #78