sql-migrate icon indicating copy to clipboard operation
sql-migrate copied to clipboard

Migration failed: pq: relation "gorp_migrations" does not exist

Open mdere-unbound opened this issue 6 years ago • 2 comments

Any reason why this could be happening? I checked my permissions for the user to access the DB and it looks good to me...what else can I be missing? Also it does seem like the sql-migrate up command too is creating the gorp_migrations table too.

mdere-unbound avatar Oct 24 '19 19:10 mdere-unbound

Same issue. Though sql-migrate creates table for migrations, migration failed with message Migration failed: pq: relation "migrations" does not exist handling 000_db_schema.sql

artn avatar Mar 16 '20 12:03 artn

I had the same issue and fixed it by providing a schema inside dbconfig.yaml:

development:
  dialect: postgres
  datasource: host=localhost port=5432 dbname=test user=user password=pass sslmode=disable
  dir: migrations
  schema: account
  table: migrations 

kkyr avatar May 11 '20 10:05 kkyr