We accidentally leaked our DATABASE_URL to the public and need to reset the created postgres user’s pw (not the superuser or ‘postgres’ account but one that was created during setup)
Is there a way to do this through flyctl other than exposing postgres instance to a public IP and logging in via DBeaver / something similar? Or what is the best / recommend approach?
Fly Postgres are normal fly apps and so they behave the same way as any other app.
Ensure you’re on the latest flyctl version and run fly ssh console -a <insert_db_app_name>
That should pop up a secure shell to the machine running your Postgres server.
From there you can run your ops commands. All the best!