Step 1: Start Your Databases
Before setting up the sync pipeline, you need both the source database (PostgreSQL) and the target database (ClickHouse) running.
Checklist
-
✔
Open ReportBurster → Starter Packs
-
✔
Start the PostgreSQL Starter Pack → wait for green status
-
✔
Start the ClickHouse Starter Pack → wait for green status
Verification Commands
Open a terminal and verify both databases are running:
docker ps | grep rb-northwind-postgres
curl "http://localhost:8123/?query=SELECT+version()"
PostgreSQL should show a running container. ClickHouse should respond with its version number (e.g., 24.3.1.2672).
Note: PostgreSQL needs WAL configuration for CDC — we'll set that up in the next step when configuring the sync pipeline.
Expected State
After completing this step:
PostgreSQL — running with sample Northwind data loaded
ClickHouse — running, empty (no tables yet)
Sync Connector — not started yet (next step)