Satellite upgrade fails at db:migrate step with error PG::InsufficientPrivilege: ERROR: must be owner of table foreman_tasks_recurring_logics

Issue

• Satellite upgrade fails with below error.

  [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: change from 'notrun' to ['0'] failed: '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0]
  

• Running foreman-rake db:migrate fails with below error

  # foreman-rake db:migrate --trace
  ** Execute db:migrate
  == 20210987654321 AddPurposeToRecurringLogic: migrating =======================
  -- add_column(:foreman_tasks_recurring_logics, :purpose, :string)
  rake aborted!
  StandardError: An error has occurred, this and all later migrations canceled:
  PG::InsufficientPrivilege: ERROR:  must be owner of table foreman_tasks_recurring_logics