Resetting Hasura migrations

If you have too many migrations and want to squash them or your current migration state on the local machine is corrupted, you can reset the state and create new migrations from the state that is on the server.

Step 1: Nuke local migrations

Delete all the contents of your local migrations directory.

$ rm migrations/*

Step 2: Reset the migration history on server

On the SQL tab of console, execute the following statement:

TRUNCATE hdb_catalog.schema_migrations;

Step 3: Pull the schema and metadata from server

Setup fresh migrations by taking the schema and metadata from the server:

## (available after version alpha45)
## create migration files (note that this will only export public schema from postgres)

$ hasura migrate create "init" --from-server

## note down the version
## mark the migration as applied on this server

$ hasura migrate apply --version "<version>" --skip-execution

Step 4: Verify the status

Execute the following command to verify status of migration:

$ hasura migrate status

You have brand new migrations now!

This can also be used to combine (kind of squash) all of your migration files into a single one. You're snapshotting the state of a server and adding it as a new migration.

Hasura is an open-source engine that gives you realtime GraphQL APIs on new or existing Postgres databases, with built-in support for stitching custom GraphQL APIs and triggering webhooks on database changes.

Shahidh K Muhammed

Shahidh K Muhammed

Design Engineer by training, Polyglot (machine & human) by day, Cook by night, #GraphQL #Kubernetes #Biriyani

Read More