我正在尝试在Rails中创建数据库。在Postgres中,我看到开发和测试数据库,但是出现了权限错误。我尝试遵循这个链接,但对我没有用。
Error: PG::InsufficientPrivilege: ERROR: permission denied for relation schema_migrations : SELECT "schema_migrations".* FROM "schema_migrations"
Rails:permission denied for relation schema_migrations
default: &default
adapter: postgresql
encoding: unicode
pool: 5
host: localhost
username: root
password:
development:
<<: *default
database: svp-chicago_development
我登录到Postgres并执行了这些命令。
psql postgres
CREATE USER root
CREATE DATABASE svp-chicago_development
GRANT ALL PRIVILEGES ON DATABASE svp-chicago_development to root
ALTER DATABASE svp-chicago_development OWNER TO root
当我执行\list
时,我看到数据库在那里。
root
用户,并将其包含在config/database.yml
文件中。 - Prakash Murthy