Yes, with a big disclaimer that "this is not managed Postgres" [1] and a list of alternatives at the end. As a hobbyist building a small website for fun, I took the hint and chose one of those.
You get to choose a region for your database, so now I'm thinking about how I want to deal with that.
[1] https://fly.io/docs/postgres/getting-started/what-you-should...