Maybe that is what Fly had in mind: That some company like Upstash would bring "managed" serverless Postgres to their platform.
Unless somebody natively implements clustering in Postgres I don't see that happening anytime soon, all existing tools require way too many moving parts.
I don't know why they'd even want Postgres for the type of service they are offering, KV or maybe SQLite seem like a better fit.