Does fly postgres attach change the postgres password?

Somehow postgres got changed, I want to figure out why

fly postgres attach generates a random password for you and you must save it somewhere cause it will never be displayed in plain text again.

So how to change the password? Detach and attach again? Will I lost my data?

@angelcervera use fly postgres connect to connect to the Postgres console as admin, then change the password for the desired user as you normally would on Postgres. Finally, update the consuming app’s DATABASE_URL with the new password.

  • Daniel