postgresql_* server settings - ClickHouse Documentation

These settings configure the ClickHouse server and are autogenerated from ClickHouse source.

postgresql_port

Port for communicating with clients over PostgreSQL protocol.

Positive integers specify the port number to listen to
Empty values are used to disable communication with clients over PostgreSQL protocol.

Example

<postgresql_port>9005</postgresql_port>

postgresql_require_secure_transport

If set to true, secure communication is required with clients over postgresql_port. Connection with option <sslmode=disable> will be refused. Use it with OpenSSL settings.

Last modified on July 22, 2026