Description of problem:
I upgraded a Satellite from 6.7.2 to 6.8 snap 9.0 and it has duplicate indexes on katello_pools:

# su - postgres -c "psql -d foreman -c 'SELECT indrelid::regclass AS TableName,array_agg(indexrelid::regclass) AS Indexes FROM pg_index GROUP BY indrelid,indkey HAVING COUNT(*) > 1;;'"
   tablename   |                       indexes                       
---------------+-----------------------------------------------------
 katello_pools | {index_katello_pools_on_cp_id,index_pools_on_cp_id}
(1 row)


How reproducible:
Deterministic

Steps to Reproduce:
1. Upgrade Satellite
2. # su - postgres -c "psql -d foreman -c 'SELECT indrelid::regclass AS TableName,array_agg(indexrelid::regclass) AS Indexes FROM pg_index GROUP BY indrelid,indkey HAVING COUNT(*) > 1;;'"

Actual results:
Duplicate indexes on katello_pools

Expected results:
No duplicate indexes (empty output)