PgBouncer
pgbouncer.default_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | How many server connections to allow per user/database pair. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 1-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.default_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.enabled
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Denotes if pgBouncer service is enabled. |
| Data type | boolean |
| Default value | false |
| Allowed values | true, false |
| Parameter type | dynamic |
| Documentation | pgbouncer.enabled |
Azure-specific notes
This server parameter is only visible when the server is running on General Purpose or Memory Optimized tiers. In Burstable tier, it is hidden and PgBouncer is not supported or available.
pgbouncer.ignore_startup_parameters
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of parameters that PgBouncer can ignore because they are going to be handled by the admin. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9_\\.,]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.ignore_startup_parameters |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_client_conn
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum number of client connections allowed. |
| Data type | integer |
| Default value | 5000 |
| Allowed values | 1-50000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_client_conn |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_prepared_statements
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | When this is set to a non-zero value PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling mode. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-5000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_prepared_statements |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.min_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Add more server connections to pool if below this number. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.min_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.pool_mode
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Specifies when a server connection can be reused by other clients. |
| Data type | enumeration |
| Default value | transaction |
| Allowed values | session,transaction,statement |
| Parameter type | dynamic |
| Documentation | pgbouncer.pool_mode |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.query_wait_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum time (in seconds) queries are allowed to spend waiting for execution. If the query is not assigned to a server during that time, the client is disconnected. |
| Data type | integer |
| Default value | 120 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.query_wait_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.server_idle_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. |
| Data type | integer |
| Default value | 600 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.server_idle_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.stats_users
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of database users that are allowed to connect and run read-only queries on the pgBouncer console. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9,@_\\-\\.]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.stats_users |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.default_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | How many server connections to allow per user/database pair. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 1-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.default_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.enabled
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Denotes if pgBouncer service is enabled. |
| Data type | boolean |
| Default value | false |
| Allowed values | true, false |
| Parameter type | dynamic |
| Documentation | pgbouncer.enabled |
Azure-specific notes
This server parameter is only visible when the server is running on General Purpose or Memory Optimized tiers. In Burstable tier, it is hidden and PgBouncer is not supported or available.
pgbouncer.ignore_startup_parameters
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of parameters that PgBouncer can ignore because they are going to be handled by the admin. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9_\\.,]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.ignore_startup_parameters |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_client_conn
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum number of client connections allowed. |
| Data type | integer |
| Default value | 5000 |
| Allowed values | 1-50000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_client_conn |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_prepared_statements
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | When this is set to a non-zero value PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling mode. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-5000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_prepared_statements |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.min_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Add more server connections to pool if below this number. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.min_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.pool_mode
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Specifies when a server connection can be reused by other clients. |
| Data type | enumeration |
| Default value | transaction |
| Allowed values | session,transaction,statement |
| Parameter type | dynamic |
| Documentation | pgbouncer.pool_mode |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.query_wait_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum time (in seconds) queries are allowed to spend waiting for execution. If the query is not assigned to a server during that time, the client is disconnected. |
| Data type | integer |
| Default value | 120 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.query_wait_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.server_idle_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. |
| Data type | integer |
| Default value | 600 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.server_idle_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.stats_users
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of database users that are allowed to connect and run read-only queries on the pgBouncer console. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9,@_\\-\\.]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.stats_users |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.default_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | How many server connections to allow per user/database pair. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 1-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.default_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.enabled
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Denotes if pgBouncer service is enabled. |
| Data type | boolean |
| Default value | false |
| Allowed values | true, false |
| Parameter type | dynamic |
| Documentation | pgbouncer.enabled |
Azure-specific notes
This server parameter is only visible when the server is running on General Purpose or Memory Optimized tiers. In Burstable tier, it is hidden and PgBouncer is not supported or available.
pgbouncer.ignore_startup_parameters
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of parameters that PgBouncer can ignore because they are going to be handled by the admin. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9_\\.,]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.ignore_startup_parameters |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_client_conn
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum number of client connections allowed. |
| Data type | integer |
| Default value | 5000 |
| Allowed values | 1-50000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_client_conn |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_prepared_statements
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | When this is set to a non-zero value PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling mode. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-5000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_prepared_statements |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.min_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Add more server connections to pool if below this number. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.min_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.pool_mode
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Specifies when a server connection can be reused by other clients. |
| Data type | enumeration |
| Default value | transaction |
| Allowed values | session,transaction,statement |
| Parameter type | dynamic |
| Documentation | pgbouncer.pool_mode |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.query_wait_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum time (in seconds) queries are allowed to spend waiting for execution. If the query is not assigned to a server during that time, the client is disconnected. |
| Data type | integer |
| Default value | 120 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.query_wait_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.server_idle_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. |
| Data type | integer |
| Default value | 600 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.server_idle_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.stats_users
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of database users that are allowed to connect and run read-only queries on the pgBouncer console. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9,@_\\-\\.]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.stats_users |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.default_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | How many server connections to allow per user/database pair. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 1-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.default_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.enabled
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Denotes if pgBouncer service is enabled. |
| Data type | boolean |
| Default value | false |
| Allowed values | true, false |
| Parameter type | dynamic |
| Documentation | pgbouncer.enabled |
Azure-specific notes
This server parameter is only visible when the server is running on General Purpose or Memory Optimized tiers. In Burstable tier, it is hidden and PgBouncer is not supported or available.
pgbouncer.ignore_startup_parameters
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of parameters that PgBouncer can ignore because they are going to be handled by the admin. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9_\\.,]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.ignore_startup_parameters |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_client_conn
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum number of client connections allowed. |
| Data type | integer |
| Default value | 5000 |
| Allowed values | 1-50000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_client_conn |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_prepared_statements
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | When this is set to a non-zero value PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling mode. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-5000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_prepared_statements |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.min_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Add more server connections to pool if below this number. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.min_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.pool_mode
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Specifies when a server connection can be reused by other clients. |
| Data type | enumeration |
| Default value | transaction |
| Allowed values | session,transaction,statement |
| Parameter type | dynamic |
| Documentation | pgbouncer.pool_mode |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.query_wait_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum time (in seconds) queries are allowed to spend waiting for execution. If the query is not assigned to a server during that time, the client is disconnected. |
| Data type | integer |
| Default value | 120 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.query_wait_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.server_idle_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. |
| Data type | integer |
| Default value | 600 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.server_idle_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.stats_users
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of database users that are allowed to connect and run read-only queries on the pgBouncer console. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9,@_\\-\\.]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.stats_users |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.default_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | How many server connections to allow per user/database pair. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 1-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.default_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.enabled
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Denotes if pgBouncer service is enabled. |
| Data type | boolean |
| Default value | false |
| Allowed values | true, false |
| Parameter type | dynamic |
| Documentation | pgbouncer.enabled |
Azure-specific notes
This server parameter is only visible when the server is running on General Purpose or Memory Optimized tiers. In Burstable tier, it is hidden and PgBouncer is not supported or available.
pgbouncer.ignore_startup_parameters
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of parameters that PgBouncer can ignore because they are going to be handled by the admin. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9_\\.,]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.ignore_startup_parameters |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_client_conn
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum number of client connections allowed. |
| Data type | integer |
| Default value | 5000 |
| Allowed values | 1-50000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_client_conn |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_prepared_statements
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | When this is set to a non-zero value PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling mode. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-5000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_prepared_statements |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.min_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Add more server connections to pool if below this number. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.min_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.pool_mode
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Specifies when a server connection can be reused by other clients. |
| Data type | enumeration |
| Default value | transaction |
| Allowed values | session,transaction,statement |
| Parameter type | dynamic |
| Documentation | pgbouncer.pool_mode |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.query_wait_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum time (in seconds) queries are allowed to spend waiting for execution. If the query is not assigned to a server during that time, the client is disconnected. |
| Data type | integer |
| Default value | 120 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.query_wait_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.server_idle_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. |
| Data type | integer |
| Default value | 600 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.server_idle_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.stats_users
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of database users that are allowed to connect and run read-only queries on the pgBouncer console. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9,@_\\-\\.]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.stats_users |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.default_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | How many server connections to allow per user/database pair. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 1-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.default_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.enabled
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Denotes if pgBouncer service is enabled. |
| Data type | boolean |
| Default value | false |
| Allowed values | true, false |
| Parameter type | dynamic |
| Documentation | pgbouncer.enabled |
Azure-specific notes
This server parameter is only visible when the server is running on General Purpose or Memory Optimized tiers. In Burstable tier, it is hidden and PgBouncer is not supported or available.
pgbouncer.ignore_startup_parameters
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of parameters that PgBouncer can ignore because they are going to be handled by the admin. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9_\\.,]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.ignore_startup_parameters |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_client_conn
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum number of client connections allowed. |
| Data type | integer |
| Default value | 5000 |
| Allowed values | 1-50000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_client_conn |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_prepared_statements
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | When this is set to a non-zero value PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling mode. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-5000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_prepared_statements |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.min_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Add more server connections to pool if below this number. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.min_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.pool_mode
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Specifies when a server connection can be reused by other clients. |
| Data type | enumeration |
| Default value | transaction |
| Allowed values | session,transaction,statement |
| Parameter type | dynamic |
| Documentation | pgbouncer.pool_mode |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.query_wait_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum time (in seconds) queries are allowed to spend waiting for execution. If the query is not assigned to a server during that time, the client is disconnected. |
| Data type | integer |
| Default value | 120 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.query_wait_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.server_idle_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. |
| Data type | integer |
| Default value | 600 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.server_idle_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.stats_users
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of database users that are allowed to connect and run read-only queries on the pgBouncer console. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9,@_\\-\\.]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.stats_users |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.default_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | How many server connections to allow per user/database pair. |
| Data type | integer |
| Default value | 50 |
| Allowed values | 1-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.default_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.enabled
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Denotes if pgBouncer service is enabled. |
| Data type | boolean |
| Default value | false |
| Allowed values | true, false |
| Parameter type | dynamic |
| Documentation | pgbouncer.enabled |
Azure-specific notes
This server parameter is only visible when the server is running on General Purpose or Memory Optimized tiers. In Burstable tier, it is hidden and PgBouncer is not supported or available.
pgbouncer.ignore_startup_parameters
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of parameters that PgBouncer can ignore because they are going to be handled by the admin. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9_\\.,]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.ignore_startup_parameters |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_client_conn
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum number of client connections allowed. |
| Data type | integer |
| Default value | 5000 |
| Allowed values | 1-50000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_client_conn |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.max_prepared_statements
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | When this is set to a non-zero value PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling mode. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-5000 |
| Parameter type | dynamic |
| Documentation | pgbouncer.max_prepared_statements |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.min_pool_size
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Add more server connections to pool if below this number. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-4950 |
| Parameter type | dynamic |
| Documentation | pgbouncer.min_pool_size |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.pool_mode
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Specifies when a server connection can be reused by other clients. |
| Data type | enumeration |
| Default value | transaction |
| Allowed values | session,transaction,statement |
| Parameter type | dynamic |
| Documentation | pgbouncer.pool_mode |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.query_wait_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Maximum time (in seconds) queries are allowed to spend waiting for execution. If the query is not assigned to a server during that time, the client is disconnected. |
| Data type | integer |
| Default value | 120 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.query_wait_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.server_idle_timeout
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. |
| Data type | integer |
| Default value | 600 |
| Allowed values | 0-86400 |
| Parameter type | dynamic |
| Documentation | pgbouncer.server_idle_timeout |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.
pgbouncer.stats_users
| Attribute | Value |
|---|---|
| Category | PgBouncer |
| Description | Comma-separated list of database users that are allowed to connect and run read-only queries on the pgBouncer console. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9,@_\\-\\.]* |
| Parameter type | dynamic |
| Documentation | pgbouncer.stats_users |
Azure-specific notes
This server parameter is only visible when pgbouncer.enabled is set to true.