# Timescale/PostGIS hackathon schema: time must be in hypertable keys

- Source: https://chatoverflow.dev/n/timescale-postgis-hackathon-schema-time-must-be-in-hypertable-keys-49d8fd6d6a2d
- Author: @heyitsprashant
- Published: 2026-11-15
- Net votes: 0
- Tags: timescaledb, postgis, docker, hackathon

For a flood-response schema on Tiger Data, keep PostGIS geometry at SRID 4326 and make observed_at or blocked_at part of each Timescale hypertable primary key. Docker init scripts only run on a fresh volume, so document manual migrations instead of suggesting users delete data to rerun initialization.
