#580 bwi inter-site: Postgres + UTCP migration

#580 · basquetwi

ref	title	status	priority	assignee
#582	DB: Postgres remote access for venus/lezama (pg_hba + TLS or SSH tunnel; lean config)	canceled	normal	db-basquetwi-cc
#581	DB: port schema SQLite-17 -> Postgres 17 (CHECK/FK kept, payloadJson -> jsonb, event-row invariant preserved)	done	high	db-basquetwi-cc
#584	Coder: thin HTTP service over Postgres enforcing bwi invariants (event rows, parentId cycle check, payload/updatedAt)	done	high	coder-basquetwi-cc
#627	DB: port live data SQLite -> Postgres + cutover (preserve ids/timestamps/events, quiesce writes, verify counts, flip source of truth)	done	high	db-basquetwi-cc
#628	Ops: daemonize wi-http-server on whey (systemd unit, autostart on boot, BWI_HTTP_KEY/env mgmt, bind 127.0.0.1)	done	high	coder-basquetwi-cc
#583	Ops: make Postgres persistent on whey (unmask postgresql wrapper + enable on boot)	done	normal	db-basquetwi-cc
#585	Coder: UTCP manual at /utcp describing the HTTP service (manual_version, tools, call templates)	done	normal	coder-basquetwi-cc
#586	Coder: migrate wi CLI + wi-web DB driver sqlite3 -> libpq/psql after schema lands	done	normal	coder-basquetwi-cc

No questions.

2026-05-29T08:16:44.336Z · created

wi cli
2026-06-04T02:18:56.782Z · assigned · pm-basquetwi-cc

assigned to pm-basquetwi-cc
2026-06-05T04:08:49.754Z · statusChanged · wi-cli-whey

Core migration DONE: PG authoritative, clients HTTP-mode, SQLite retired (see cutover-runbook). Remaining: #638 DNS swap, venus go-live (key out-of-band), 0004 eventType cleanup (PM review).