Heroku Free Tier Deprecation | Migrating to other DB vendors

Heroku is deprecating free resource plans, including Heroku Dynos and Heroku Postgres, starting November 28th. As a Hasura Cloud user, you will need to upgrade your Heroku account or migrate your Heroku Postgres database to another vendor before the deadline. This post provides step-by-step instructions on how to take a backup of your Heroku Postgres DB and Hasura Metadata/Migrations for migration purposes. The process involves using pg_dump to export the database, importing the SQL into a new vendor's instance, creating migration files and metadata with the Hasura CLI, connecting the new database as a data source in Hasura, applying migrations and metadata, and verifying the new connection and API by trying out a GraphQL query.