Configuration

PgDog provides real time access to its current configuration values. They can be accessed by connecting to the admin database and running the SHOW CONFIG command:

SHOW CONFIG;

The following configuration parameters are available and their current values:

Name	Example
`auth_type`	`scram`
`ban_timeout`	`5m`
`broadcast_address`	`default`
`broadcast_port`	`6433`
`checkout_timeout`	`1s`
`client_idle_timeout`	`18446744073709551615ms`
`connect_attempt_delay`	`0ms`
`connect_attempts`	`1`
`connect_timeout`	`1s`
`cross_shard_disabled`	`false`
`default_pool_size`	`10`
`dns_ttl`	`default`
`dry_run`	`false`
`healthcheck_interval`	`30s`
`healthcheck_timeout`	`5s`
`host`	`0.0.0.0`
`idle_healthcheck_delay`	`5s`
`idle_healthcheck_interval`	`30s`
`idle_timeout`	`1m`
`load_balancing_strategy`	`round_robin`
`log_connections`	`true`
`log_disconnections`	`true`
`min_pool_size`	`1`
`mirror_exposure`	`1.0`
`mirror_queue`	`128`
`openmetrics_namespace`	`pgdog_`
`openmetrics_port`	`9090`
`passthrough_auth`	`disabled`
`pooler_mode`	`transaction`
`port`	`6432`
`prepared_statements`	`extended`
`prepared_statements_limit`	`500`
`pub_sub_channel_size`	`4098`
`query_cache_limit`	`500`
`query_log`	`default`
`query_timeout`	`1s`
`read_write_split`	`include_primary`
`read_write_strategy`	`aggressive`
`rollback_timeout`	`1s`
`shutdown_timeout`	`1m`
`tls_certificate`	`default`
`tls_private_key`	`default`
`tls_server_ca_certificate`	`default`
`tls_verify`	`prefer`
`two_phase_commit`	`false`
`two_phase_commit_auto`	`default`
`workers`	`2`
`tcp_congestion_control`	`default`
`tcp_interval`	`default`
`tcp_keepalive`	`true`
`tcp_retries`	`default`
`tcp_time`	`default`
`tcp_user_timeout`	`default`