Skip to content
ClickHouse Docs

postgresql_connection_* session settings

Autogenerated from ClickHouse system tables

These settings are available in system.settings and are autogenerated from the ClickHouse snapshot.

postgresql_connection_attempt_timeout

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

Close connection before returning connection to the pool.

postgresql_connection_pool_retries

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

postgresql_connection_pool_size

Connection pool size for PostgreSQL table engine and database engine.

postgresql_connection_pool_wait_timeout

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