In Red Hat Satellite 6 with external PostgreSQL database satellite-installer --reset-data command fails with error could not connect to server Connection refused

Issue

• In Red Hat Satellite 6 with external PostgreSQL database satellite-installer --reset-data command fails with error:

  # satellite-installer -v --reset-data
  20XX-XX-XX 20:XX:XX [NOTICE] [root] Loading installer configuration. This will take some time.
  20XX-XX-XX 20:XX:XX [NOTICE] [root] Running installer with log based terminal output at level NOTICE.
  20XX-XX-XX 20:XX:XX [NOTICE] [root] Use -l to set the terminal output log level to ERROR, WARN, NOTICE, INFO, or DEBUG. See --full-help for definitions.
  Are you sure you want to continue? This will drop the databases, reset all configurations that you have made and bring all application data back to a fresh install. [y/n]
  y
  20XX-XX-XX 20:XX:XX [NOTICE] [pre] Dropping foreman database!
  psql: error: could not connect to server: Connection refused
         Is the server running on host "192.168.XX.X" and accepting
         TCP/IP connections on port 5432?
  20XX-XX-XX 20:XX:XX [ERROR ] [root] PGPASSWORD='****************d' psql -U foreman -h 192.168.XX.X -p 5432 -d foreman -t -c "" failed! Check the output for error!
  

• hammer ping fails with below error:

  # hammer ping
  Warning: An error occured while loading module hammer_cli_csv.
  Error: Failed to open TCP connection to satellite.example.com:443 (Connection refused - connect(2) for "satellite.example.com" port 443)