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!
Cheers - thanks for the quick response!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.