PgCat

PostgreSQL pooler and proxy with load balancing, failover, mirroring and experimental sharding.

Provider: default
Kind: Database proxy
Category: Data
Official docs: https://github.com/postgresml/pgcat

Properties · 2 set by this component

property	type	values	required	kind default	this component
hedging · advanced	boolean	—	no	false	inherited
loadShedding · advanced	boolean	—	no	false	inherited
managed	boolean	—	no	false	inherited
mirroring · component property	boolean	—	no	false	inherited
poolMode · component property	enum	session \| transaction	no	transaction	inherited
poolSharded · advanced	boolean	—	no	false	inherited
pooling	boolean	—	no	true	▸ true
queryParser · component property	boolean	—	no	false	inherited
requestCoalescing · advanced	boolean	—	no	false	inherited
routing	enum	none \| shard-key \| lookup	no	none	▸ none
scatterGather · advanced	boolean	—	no	false	inherited
sharding · component property	boolean	—	no	false	inherited

Rules that apply · 0

Every rule whose selector covers this component's kind or its category. Whether a rule fires depends on the design: its properties, its edges and its groups.

No rule reads this kind yet. That is a gap, not a guarantee.

Use it in a design

nodes:
  - { id: "pgcat", component: "pgcat" }

Other Database proxy products · 13

Amazon RDS Proxyrds-proxyawsdatabase-proxy Cloudflare Hyperdrivecloudflare-hyperdrivecloudflaredatabase-proxy Generic database proxydatabase-proxydatabase-proxy MariaDB MaxScalemaxscaledatabase-proxy mongosmongosdatabase-proxy Odysseyodysseydatabase-proxy PgBouncerpgbouncerdatabase-proxy Pgpool-IIpgpooldatabase-proxy ProxySQLproxysqldatabase-proxy Supavisorsupavisordatabase-proxy Vitessvitessdatabase-proxy Cloud SQL Auth Proxygoogle-cloud-sql-auth-proxygcpdatabase-proxy IBM Data Virtualizationibm-data-virtualizationibmdatabase-proxy

Source

1# yaml-language-server: $schema=../../schema/component.schema.json
2# PgCat: PostgreSQL pooler and proxy with load balancing, failover, mirroring and sharding.
3# README "Features": transaction pooling is the default mode; sharding and mirroring are
4# experimental and off until configured, so routing stays "none" out of the box.
5schemaVersion: "1"
6type: "component"
7id: "pgcat"
8kind: "database-proxy"
9provider: "default"
10docs: "https://github.com/postgresml/pgcat"
11defaults:
12  pooling: true
13  routing: "none"
14properties:
15  poolMode:
16    type: "enum"
17    values: ["session", "transaction"]
18    default: "transaction"
19  queryParser:
20    type: "boolean"
21    default: false
22  sharding:
23    type: "boolean"
24    default: false
25  mirroring:
26    type: "boolean"
27    default: false

The same page as markdown, for an agent: /catalogue/components/pgcat.md