CODEWITHSUNDEEP
ruby-on-railspostgresql
Jayashri
Jayashri

Reputation: 4333

PGError:Error: must be owner of relation

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

PGError:Error: must be owner of relation table_name

I don't understand why this error occurs? Please suggest any solution to resolve this error.

Thanks!

Upvotes: 4

Views: 12147

Answers (1)

Frank Heikens
Frank Heikens

Reputation: 126970

You want to change something in the table, but you don't have the permissions to do so. Only the owner of the table can do so.

Use a different database role, the owners role, and you're fine.

Upvotes: 1

Related Questions