Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

postgresql_connection_* session settings

These settings are available in system.settings and are autogenerated from source.

postgresql_connection_attempt_timeout

Type
UInt64
Default
2
Version history
VersionDefault valueComment
24.72Allow to control 'connect_timeout' parameter of PostgreSQL connection.

Connection timeout in seconds of a single attempt to connect PostgreSQL end-point. The value is passed as a connect_timeout parameter of the connection URL.

postgresql_connection_pool_auto_close_connection

Type
Bool
Default
0

Close connection before returning connection to the pool.

postgresql_connection_pool_retries

Type
UInt64
Default
2
Version history
VersionDefault valueComment
24.72Allow to control the number of retries in PostgreSQL connection pool.

Connection pool push/pop retries number for PostgreSQL table engine and database engine.

postgresql_connection_pool_size

Type
UInt64
Default
16

Connection pool size for PostgreSQL table engine and database engine.

postgresql_connection_pool_wait_timeout

Type
UInt64
Default
5000

Connection pool push/pop timeout on empty pool for PostgreSQL table engine and database engine. By default it will block on empty pool.

Navigation