I’ve some success, but for some reason now having trouble connecting a service to the database:
- I have the right url from
flyctl postgres attach --postgres-app dbnamebeing passed. (one note there, would be nice if you output a exit 0 saying “already attached” if you run this again)
- I can psql into the database using the url provided once I have wireguard locally running
- dig _apps.internal shows the database but not the other service (because it won’t start due to connection issues)
- on startup the failed app (Hasura app) outputs: “could not translate host name “dish-db.internal” to address: Name or service not known”
I’ll try creating a new one and just see if somehow it’s stuck in a weird state, but any help on how to generally debug this would be great.
Edit: Ah yes, must have been some sort of state bug, after delete and recreate it connected fine.
Edit 2: Seems I needed to re-create apps for it to work again, not sure what happened but after delete + create three of them now connect with *no other changes.