type: object
properties:
name:
type: string
description: >-
A unique name for the connection pool. Must be between 3 and 60 characters.
example: backend-pool
mode:
type: string
description: >-
The PGBouncer transaction mode for the connection pool. The allowed
values are session, transaction, and statement.
example: transaction
size:
type: integer
format: int32
description: >-
The desired size of the PGBouncer connection pool. The maximum allowed
size is determined by the size of the cluster's primary node. 25 backend
server connections are allowed for every 1GB of RAM. Three are reserved
for maintenance. For example, a primary node with 1 GB of RAM allows for
a maximum of 22 backend server connections while one with 4 GB would
allow for 97. Note that these are shared across all connection pools in
a cluster.
example: 10
db:
type: string
description: The database for use with the connection pool.
example: defaultdb
user:
type: string
description: >-
The name of the user for use with the connection pool. When excluded,
all sessions connect to the database as the inbound user.
example: doadmin
connection:
allOf:
- $ref: './database_connection.yml'
- readOnly: true
private_connection:
allOf:
- $ref: './database_connection.yml'
- readOnly: true
standby_connection:
allOf:
- $ref: './database_connection.yml'
- readOnly: true
standby_private_connection:
allOf:
- $ref: './database_connection.yml'
- readOnly: true
required:
- name
- mode
- size
- db