Installing puppetdb (puppetlabs-puppetdb module) on foreman 3.x katello 4.x

Trying to install puppetlabs-puppetdb on foreman 3.2 / katello 4.4 but running into various problems, one of which is that foreman uses CentOS repos for postgresql whereas the puppetdb module uses the official postgres repos. Puppetdb expects a suffix for postgres (ie postgresql-12) whereas there is no suffix on the standard CentOS repos version. This leads to problems running foreman-installer with puppetdb. Has anybody got step by step instructions on how to get puppetdb working alongside foreman 3.2 with katello 4.4 and puppetserver 7?
Expected outcome:
Be able to successfully install puppetdb alongside foreman 3.2
Foreman and Proxy versions:
Foreman and Proxy plugin versions:
Distribution and version:
CentOS Stream 8
Other relevant data: