[Satellite 6] How to manage postgresql.conf and pg_hba.conf files with satellite

Issue

• The Security team would like to remotely connect to the postgreSQL 'foreman' database directly to collect per host errata stats. how to give access to external user from a specific server.

• How to configure postgresql.conf and pg_hba.conf so that the modifications do not get overwritten by a Satellite installer run.

• How to configure postgresql.conf and pg_hba.conf as below:

  postgresql.conf:
  listen_addresses = '*'
  
  pg_hba.conf:
  # Rule Name: allow access to external user
  # Description: Permit connection from 192.0.2.1 to foreman database
  # Order: 100
  #host   DATABASE        USER            ADDRESS         METHOD  [OPTIONS]
  host    foreman         externaluser        192.0.2.1/24              md5