marchelbling

#!/bin/bash

role=citus
database=citus
port=5432
workers=2
timeout=30

# start cluster with 2 workers
[ -f docker-compose.yml ] || wget https://raw.githubusercontent.com/citusdata/docker/master/docker-compose.yml

marchelbling

-- user:
CREATE ROLE citus WITH NOSUPERUSER LOGIN IN ROLE pg_monitor;

-- database:
ALTER DATABASE citus SET citus.shard_replication_factor = 1;
ALTER DATABASE citus OWNER TO citus;

-- extensions:
CREATE EXTENSION IF NOT EXISTS "hll";
CREATE EXTENSION IF NOT EXISTS "topn";