I installed Foreman few months ago over an existing Puppet/PuppetDB installation.
As of today, everything was ok but I now have to use a Postgresql database which is not related to PuppetDB or Foreman.
The problem is that Postgresql is now managed by Foreman and I can’t modify the pg_hba.conf file to accept incoming requests for this new database.
As I’m using Foreman as a facts report only GUI, how can I add a new pg_hba rule without assigning classes definitions with Foreman?
Where can I find the pg_hba configuration Foreman used to store its data?
As a side note, we don’t and don’t want to use Foreman as an ENC as every host configuration is managed along roles/profiles in our VCS.