Contents

• Installing pg_stat_ch

Installing pg_stat_ch

The extension is self-contained with all dependencies (including clickhouse-cpp) statically linked. No additional shared libraries are required at runtime.

1. Copy files to PostgreSQL directories: bash sudo cp pg_stat_ch.so $(pg_config --pkglibdir)/ sudo cp pg_stat_ch.control pg_stat_ch--*.sql $(pg_config --sharedir)/extension/

2. Add to postgresql.conf: shared_preload_libraries = 'pg_stat_ch'

3. Restart PostgreSQL and create extension: sql CREATE EXTENSION pg_stat_ch;