ActiveRecord :: StatementInvalid: PG :: InsufficientPrivilege: ERROR: permission denied for schema_migrations

I have a local project with rails and postgres. I threw it on AMIS AMASON Linux. I ran test projects with rails and postgres on the server. However, when I loaded my local project and tried to run

rake db:migrate

I get the following error:

ActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR:  permission denied for relation schema_migrations

I saw some similar problems, but none of them help. I have the correct role setting and connection.

+4
source share
1 answer

, rake db:migrate RAILS_ENV . ( ), config/database.yml , , . ALL public.schema_migrations. , , , public.

postgres . Postgres .

: , rake db:schema:load rake db:migrate. , !

+3

Source: https://habr.com/ru/post/1599340/


All Articles