migration failure over user permissions

Issue #32 new
gary_lucas created an issue

I'm getting: (pq: must be member of role "postgres"), quitting migration.

I'm attempting to use a less privileged login role and I'm getting this error on the new login role. WHen I make that login role 'superuser' the problem goes away.

However when I log into the DB via psql or pgadmin I can execute the scripts without the superuser option, which leaves me kind of confused.

Anyone have an idea as to how this is happening? Presumably goose is adding some boilerplate sql that requires superuser access?

Comments (0)

  1. Log in to comment