Remove all references to the migrations user and the migrations role

The migrations user/role used to be used for....you guessed it....migrations but it no longer works that way. Instead a postgres user is used to manage migrations.