Справочник по pg_clickhouse

docker run --name pg_clickhouse -e POSTGRES_PASSWORD=my_pass \
       -d ghcr.io/clickhouse/pg_clickhouse:19
docker exec -it pg_clickhouse psql -U postgres -c 'CREATE EXTENSION pg_clickhouse'

sudo apt install \
  postgresql-server-19 \
  libcurl4-openssl-dev \
  uuid-dev \
  libssl-dev \
  make \
  cmake \
  g++

sudo yum install \
  postgresql-server \
  libcurl-devel \
  libuuid-devel \
  openssl-libs \
  automake \
  cmake \
  gcc

pgxn install pg_clickhouse

make
sudo make install

export PG_CONFIG=/usr/lib/postgresql/18/bin/pg_config
make
sudo make install

export CURL_CONFIG=/opt/homebrew/opt/curl/bin/curl-config
make
sudo make install

"Makefile", line 8: Need an operator

gmake
gmake install
gmake installcheck

make: pg_config: Command not found

export PG_CONFIG=/path/to/pg_config
make
sudo make install

sudo make install prefix=/usr/local/extras

extension_control_path = '/usr/local/extras/postgresql/share:$system'
dynamic_library_path   = '/usr/local/extras/postgresql/lib:$libdir'

make installcheck

ERROR:  must be owner of database regression

make installcheck PGUSER=postgres

CREATE EXTENSION pg_clickhouse;

CREATE SCHEMA env;
CREATE EXTENSION pg_clickhouse SCHEMA env;