I think a bit of confusion on Fly Postgres vs. the Supabase offering. The earlier was unmanaged on Fly infra.
I'm not sure the full details on supabase as it's more recent.
This is a pretty good breakdown of various database providers and in particular a lot paired with Fly - https://dancroak.com/webstack/