Postgres setup user

[quyen91]

Go to postgresql console sudo -u postgres psql postgres

Create user rails_dev create role rails_dev with createdb login password 'aqwe123';

Drop database drop database blog_development;

Ref: https://serverfault.com/a/325596 https://www.howtoforge.com/tutorial/ruby-on-rails-ror-with-postgresql-on-ubuntu-16-04/

[quyen91]

Error PGError: ERROR: permission denied for relation schema_migrations : SELECT version FROM schema_migrations

Solution:

• Change role of your custom user to superuser ALTER ROLE rails_user with superuser;