hasura / graphql-engine-heroku

Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events.
https://hasura.io
231 stars 233 forks source link

Error when upgrading Postgres version #74

Open 2mol opened 4 years ago

2mol commented 4 years ago

I've swapped out the underlying database for version 12.1 on Heroku. I'm now getting errors similar to #57, and I'm unable to reset the metadata.

When resetting the metadata in the console, I get "unexpected : relation "hdb_catalog.hdb_function" does not exist".

I know I could have followed a proper migration as described in the docs, but there wasn't any data yet, so I just intend to set the Postgres version to 12.1 and then load data into it from a dump.

Is the intention that you can't do a hard-reset of Hasura's metdata on a fresh DB without going through the procedure of backing up the metadata?