PGError: Error: Must be the owner of the relationship

Question

I have a rails application with a PostgreSql database. My application works fine with PostgreSql. I want to start the migration on the server, I run the command RAILS_ENV = production rake db: migrate then I get the following error:

PGError: Error: must be owner table_name relation

I do not understand why this error occurs? Please suggest any solution to resolve this error.

Thanks!

Answer 1

You want to change something in the table, but you do not have permission to do so. Only the owner of the table can do this.

Use a different database role, the owner role, and everything is fine.