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:~$
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
