Issue when migrating events resolved by running SQL below. User needed updating when running in prod. 

CREATE TABLE IF NOT EXISTS hdb_catalog.hdb_source_catalog_version
(
    version text COLLATE pg_catalog."default" NOT NULL,
    upgraded_on timestamp with time zone NOT NULL
)

TABLESPACE pg_default;

ALTER TABLE hdb_catalog.hdb_source_catalog_version
    OWNER to postgres;
-- Index: hdb_source_catalog_version_one_row

-- DROP INDEX hdb_catalog.hdb_source_catalog_version_one_row;

CREATE UNIQUE INDEX hdb_source_catalog_version_one_row
    ON hdb_catalog.hdb_source_catalog_version USING btree
    ((version IS NOT NULL) ASC NULLS LAST)
    TABLESPACE pg_default;

INSERT INTO hdb_catalog.hdb_source_catalog_version (version, upgraded_on) VALUES ('2', NOW());

https://devscope.io/code/hasura/graphql-engine/issues/8694