Postgres Can't Migrate

[LillySchramm]

Describe the bug

When setting up a new instance using a Postgres Database the initial migration always fails.

gowitness-1  | 2025/12/22 23:16:08 github.com/sensepost/gowitness/pkg/database/db.go:77 ERROR: type "longtext" does not exist (SQLSTATE 42704)
gowitness-1  | [0.400ms] [rows:0] CREATE TABLE "results" ("id" bigserial,"url" text,"probed_at" timestamptz,"final_url" text,"response_code" bigint,"response_reason" text,"protocol" text,"content_length" bigint,"html" longtext,"title" text,"perception_hash" text,"perception_hash_group_id" bigint,"screenshot" text,"filename" text,"is_pdf" boolean,"failed" boolean,"failed_reason" text,PRIMARY KEY ("id"))
gowitness-1  | 2025/12/22 23:16:08 ERRO could not get api handler up err="ERROR: type \"longtext\" does not exist (SQLSTATE 42704)"

Postges 17

[LillySchramm]

I have written a quickfix here: LillySchramm@4135026

this does however screw with the indexes because i could not get length to work