I also need to connect with my db, and have been unable to so do via any of the commands in the fly postgres command tree. I can guess at the connection string based on the parameters given when the database was created, but so far I’ve been unable to get psql to parse the hostname due to error: ‘could not translate host name “[redacted_hostname]” to address: nodename nor servname provided, or not known’
I’ll keep playing around and report back if I get unblocked.
Simple database (and/or application console) access feels like it should be table stakes for a PaaS offering, and I have a feeling I may have missed something in the manual…
Found some guidance at gui for a postgres db on fly io - #4 by rookie, in that you can use fly postgres connect, but the app you pass via the -a flag is, somewhat confusingly, the -db suffixed “app”, instead of the actual app that you created the postgres instance for.