Question
Apps using "postgres" user instead of my_user in the database
- Posted on June 24, 2023
- ApplicationsDatabaseDigitalOcean 1-Click Apps MarketplaceRuby on Rails
Asked by Kainat Naz
My postgres databse keeps the value postgres for database name even when I create new db and new user. It seems that no matter what I do, I cannot alter it.facing the error I want to use my database name and user when i change the database name to “postgres” and username into “doadmin” application connecting to the database else showing this error on change the name of my db and user
apps@feedback-app-7-jx2mf:~$ rails db:migrate
rails aborted!
ActiveRecord::StatementInvalid: PG:: Insufficient Privilege: ERROR: permission denied for table schema_migrations /workspace/bin/rails:5:in `<main>'
Caused by:
PG:: InsufficientPrivilege: ERROR: permission denied for table schema_migrations
/workspace/bin/rails:5:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace) apps@feedback-app-7-jx2mf:~$
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hollie's Hub for Good
Working on improving health and education, reducing inequality, and spurring economic growth? We’d like to help.
Get started for free
Enter your email to get $200 in credit for your first 60 days with DigitalOcean.
New accounts only. By submitting your email you agree to our Privacy Policy.
This help me in resolving this error
GRANT ALL PRIVILEGES ON DATABASE your_database to your_database_user; ALTER DATABASE your_database OWNER TO your_database_user;
Hi there,
Once you’ve added your new database user, you would also need to add the required privileges so that the user would have access to your database in question.
With the DigitalOcean Managed database clusters, you can do that by following the steps from the documentation here:
your_userwith your user name:Let me know how it goes after that!
Best,
Bobby