I finally found the answer here Create index already exists. It’s a Postgres index name length issue. Postgres index name is limited to 63 characters. Consequently we need to shorten the content types names for the deployment to work. Amazing! 
I finally found the answer here Create index already exists. It’s a Postgres index name length issue. Postgres index name is limited to 63 characters. Consequently we need to shorten the content types names for the deployment to work. Amazing!