{"repo":"postgresml/pgcat","free":true,"listed":false,"github":"https://github.com/postgresml/pgcat","clone":"git clone https://github.com/postgresml/pgcat.git","description":"PostgreSQL pooler with sharding, load balancing and failover support.","language":"Rust","stars":4004,"topics":["pooler","postgresql","pooling","rust"],"license":"MIT","category":"databases-storage","readme_excerpt":"PgCat: Nextgen PostgreSQL Pooler PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring. Features Feature Status Comments ------------- ------------ -------------- Transaction pooling Stable Identical to PgBouncer with notable improvements for handling bad clients and abandoned transactions. Session pooling Stable Identical to PgBouncer. Multi-threaded runtime Stable Using Tokio asynchronous runtime, the pooler takes advantage of multicore machines. Load balancing of read queries Stable Queries are automatically load balanced between replicas and the primary. Failover Stable Queries are automatically rerouted around broken replicas, validated by regular health checks. Admin database statistics Stable Pooler statistics and administration via the pgbouncer and pgcat databases. Prometheus statistics Stable Statistics are reported via a HTTP endpoint for Prometheus. SSL/TLS Stable Clients can connect to the pooler using TLS. Pooler can connect to Postgres servers using TLS. Client/Server authentication Stable Clients can connect using MD5 authentication, supported by libpq and all Postgres client drivers. PgCat can connect to Postgres using MD5 and SCRAM-SHA-256. Live configuration reloading Stable Identical to PgBouncer; all settings can be reloaded dynamically (except host and port ). Auth passthrough Stable MD5 password authentication can be configured to use an auth query so no cleartext passwords are needed in the confi","default_branch":null,"files":null,"tree":[],"storefront":"/r/postgresml","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/postgresml/pgcat/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}