The connection pooling CR represent the configuration of PgBouncer.
Kind: SGPoolingConfig
listKind: SGPoolingConfigList
plural: sgpoolconfigs
singular: sgpoolconfig
Spec
| Property | Required | Updatable | Type | Default | Description |
|---|---|---|---|---|---|
| pgBouncer | ✓ | object | see below |
Connection pooling configuration based on PgBouncer.
|
| Property | Required | Updatable | Type | Default | Description |
|---|---|---|---|---|---|
| pgbouncer.ini | ✓ | object | see below |
The Check pgbouncer configuration for more information about supported parameters. |
Default value of pgbouncer.ini property:
pool_mode: session
max_client_conn: "1000"
Example:
apiVersion: stackgres.io/v1beta1
kind: SGPoolingConfig
metadata:
name: pgbouncerconf
spec:
pgbouncer.ini:
pool_mode: 'transaction'
max_client_conn: '2000'
To guarantee a functional pgbouncer configuration most of the parameters specified in
pgbouncer configuration documentation
for section [pgbouncer] have been blacklisted and will be ignored. The only parameters that can
be changed are:
| Whitelisted parameter |
|---|
| pool_mode |
| max_client_conn |
For reference this is the list of parameters that will be ignored:
| Blacklisted parameter |
|---|
| logfile |
| pidfile |
| listen_addr |
| listen_port |
| unix_socket_dir |
| unix_socket_mode |
| unix_socket_group |
| user |
| auth_file |
| auth_hba_file |
| auth_type |
| auth_query |
| auth_user |
| default_pool_size |
| min_pool_size |
| reserve_pool_size |
| reserve_pool_timeout |
| max_db_connections |
| max_user_connections |
| server_round_robin |
| ignore_startup_parameters |
| disable_pqexec |
| application_name_add_host |
| conffile |
| service_name |
| job_name |
| stats_period |
| syslog |
| syslog_ident |
| syslog_facility |
| log_connections |
| log_disconnections |
| log_pooler_errors |
| log_stats |
| verbose |
| admin_users |
| stats_users |
| server_check_delay |
| server_check_query |
| server_fast_close |
| server_lifetime |
| server_idle_timeout |
| server_connect_timeout |
| server_login_retry |
| client_login_timeout |
| autodb_idle_timeout |
| dns_max_ttl |
| dns_nxdomain_ttl |
| dns_zone_check_period |
| client_tls_sslmode |
| client_tls_key_file |
| client_tls_cert_file |
| client_tls_ca_file |
| client_tls_protocols |
| client_tls_ciphers |
| client_tls_ecdhcurve |
| client_tls_dheparams |
| server_tls_sslmode |
| server_tls_ca_file |
| server_tls_key_file |
| server_tls_cert_file |
| server_tls_protocols |
| server_tls_ciphers |
| query_timeout |
| query_wait_timeout |
| client_idle_timeout |
| idle_transaction_timeout |
| pkt_buf |
| max_packet_size |
| listen_backlog |
| sbuf_loopcnt |
| suspend_timeout |
| tcp_defer_accept |
| tcp_socket_buffer |
| tcp_keepalive |
| tcp_keepcnt |
| tcp_keepidle |
| tcp_keepintvl |