Chapter 4. Installing and configuring automation hub on Red Hat OpenShift Container Platform web console

Procedure

1. Click Advanced configuration.
2. Under Ingress type, click the drop-down menu and select Route.
3. Under Route DNS host, enter a common host name that the route answers to.
4. Under Route TLS termination mechanism, click the drop-down menu and select Edge or Passthrough.
5. Under Route TLS credential secret, click the drop-down menu and select a secret from the list.

Procedure

1. Click Advanced Configuration.
2. Under Ingress type, click the drop-down menu and select Ingress.
3. Under Ingress annotations, enter any annotations to add to the ingress.
4. Under Ingress TLS secret, click the drop-down menu and select a secret from the list.

Procedure

1. Check if the extension is available on the PostgreSQL server (automation hub database).

   $ psql -d <automation hub database> -c "SELECT * FROM pg_available_extensions WHERE name='hstore'"

   Where the default value for <automation hub database> is automationhub.

   Example output with hstore available:

   name  | default_version | installed_version |comment
   ------+-----------------+-------------------+---------------------------------------------------
    hstore | 1.7           |                   | data type for storing sets of (key, value) pairs
   (1 row)

   Example output with hstore not available:

    name | default_version | installed_version | comment
   ------+-----------------+-------------------+---------
   (0 rows)

2. On a RHEL based server, the hstore extension is included in the postgresql-contrib RPM package, which is not installed automatically when installing the PostgreSQL server RPM package.

   To install the RPM package, use the following command:

   dnf install postgresql-contrib

3. Create the hstore PostgreSQL extension on the automation hub database with the following command:

   $ psql -d <automation hub database> -c "CREATE EXTENSION hstore;"

   The output of which is:

   CREATE EXTENSION

4. In the following output, the installed_version field contains the hstore extension used, indicating that hstore is enabled.

   name | default_version | installed_version | comment
   -----+-----------------+-------------------+------------------------------------------------------
   hstore  |     1.7      |       1.7         | data type for storing sets of (key, value) pairs
   (1 row)