Zeema
New design
Catalogue / database-proxy

Pgpool-II

Database proxypgpool

PostgreSQL middleware providing connection pooling, SELECT load balancing, query cache and failover.

Provider
default
Kind
Database proxy
Category
Data
Official docs
https://www.pgpool.net/docs/latest/en/html/runtime-config-connection-pooling.html
Properties · 2 set by this component
propertytypevaluesrequiredkind defaultthis component
hedging · advancedboolean—nofalseinherited
loadBalanceMode · component propertyboolean—notrueinherited
loadShedding · advancedboolean—nofalseinherited
managedboolean—nofalseinherited
maxPool · component propertyinteger—no4inherited
memoryCacheEnabled · component propertyboolean—nofalseinherited
poolSharded · advancedboolean—nofalseinherited
poolingboolean—notrue▸ true
requestCoalescing · advancedboolean—nofalseinherited
routingenumnone | shard-key | lookupnonone▸ none
scatterGather · advancedboolean—nofalseinherited
statementLevelLoadBalance · component propertyboolean—nofalseinherited
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: "pgpool", component: "pgpool" }
Other Database proxy products · 13
Amazon RDS Proxyrds-proxyawsdatabase-proxyCloudflare Hyperdrivecloudflare-hyperdrivecloudflaredatabase-proxyGeneric database proxydatabase-proxydatabase-proxyMariaDB MaxScalemaxscaledatabase-proxymongosmongosdatabase-proxyOdysseyodysseydatabase-proxyPgBouncerpgbouncerdatabase-proxyPgCatpgcatdatabase-proxyProxySQLproxysqldatabase-proxySupavisorsupavisordatabase-proxyVitessvitessdatabase-proxyCloud SQL Auth Proxygoogle-cloud-sql-auth-proxygcpdatabase-proxyIBM Data Virtualizationibm-data-virtualizationibmdatabase-proxy
Source
# yaml-language-server: $schema=../../schema/component.schema.json
# Pgpool-II: PostgreSQL middleware doing connection pooling, load balancing and failover.
# "Connection Pooling" and "Load Balancing" runtime config: connection_cache is on,
# max_pool is 4, load_balance_mode is on and memory_cache_enabled is off by default.
schemaVersion: "1"
type: "component"
id: "pgpool"
kind: "database-proxy"
provider: "default"
docs: "https://www.pgpool.net/docs/latest/en/html/runtime-config-connection-pooling.html"
defaults:
  pooling: true
  routing: "none"
properties:
  loadBalanceMode:
    type: "boolean"
    default: true
  maxPool:
    type: "integer"
    default: 4
  memoryCacheEnabled:
    type: "boolean"
    default: false
  statementLevelLoadBalance:
    type: "boolean"
    default: false

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