Lab 1 — Solutions¶
Task 1.1 — Installed extensions¶
SELECT extname, extversion FROM pg_extension
WHERE extname IN ('citus', 'postgis') ORDER BY 1;
-- or simply: \dx
Answer: Citus 13.4-1 and PostGIS 3.7 are installed. PostGIS is the
geospatial engine the geofencing labs use for ST_DWithin / ST_Contains.
(Your minor versions may differ if the image tag in docker-compose.yml or
db/Dockerfile has been updated — that is expected.)
Task 1.2 — Active workers¶
Answer: 3 active workers. You can also inspect pg_dist_node for the
full node registry (includes the coordinator once it's registered, plus
inactive nodes if any).