Installing and configuring EDB Postgres AI for ClickHouse

Plan your deployment and install EDB Postgres AI for ClickHouse on your infrastructure.

Deployment options

Your topology determines how data is stored, replicated, and served, as well as how much operational complexity you take on. For a full explanation of sharding, replication, and ClickHouse Keeper, see ClickHouse architecture .

Single-node

ClickHouse runs as a standalone instance on a single host. No cluster coordination is needed. Suitable for development, testing, and single-tenant analytical workloads.

Multi-node cluster

Data is distributed across shards for horizontal scale and replicated for high availability. Replication requires ClickHouse Keeper running on at least three nodes. Keeper can run co-located on server nodes or on separate dedicated nodes.

Choosing an installation method

EDB provides three ways to install ClickHouse:

• Installing EDB Postgres AI for ClickHouse on Rocky Linux

• Installing EDB Postgres AI for ClickHouse with Docker

• Installing EDB Postgres AI for ClickHouse on Kubernetes

• Installing EDB Postgres AI for ClickHouse on Rocky Linux
  • Prerequisites
  • Deploying a single node
  • Deploying a cluster
    • Installing packages
    • Configuring Keeper
    • Configuring the servers
    • Starting services
    • Connecting to the cluster
    • Testing replication and sharding
• Installing EDB Postgres AI for ClickHouse with Docker
  • Prerequisites
  • Pulling the image
  • Running a single-node server
  • Running a multi-node cluster
    • Creating the configuration files
    • Creating the Compose file
    • Starting and verifying the cluster
    • Testing replication and sharding
• Installing EDB Postgres AI for ClickHouse on Kubernetes
  • Prerequisites
  • Creating the image pull secret
  • Installing the operator
  • Creating a ClickHouse cluster
  • Connecting to ClickHouse
  • Uninstalling