To setup a remote Postgresql database instance on Oracle Linux 8 for Oracle Linux Automation Manager single host configuration, do the following:

1. Install Oracle Linux 8 on a host.
2. Open the database port in the firewall:

   sudo firewall-cmd --add-port=5432/tcp --permanent
   sudo firewall-cmd --reload

3. Enable the postgresql 13 module stream.

   sudo dnf module reset postgresql
   sudo dnf module enable postgresql:13

   Note:

   For more information about the Postgresql 13 life cycle, see the appendix discussing the application life cycle for stream modules in Oracle Linux: Managing Software on Oracle Linux.
4. Install the database.

   sudo dnf install postgresql-server postgresql-contrib

5. Initialize the database:

   sudo postgresql-setup --initdb

6. In the /var/lib/pgsql/data/postgresql.conf file, switch the password storage mechanism from md5 to scram-sha-256. For example, the following command makes the switch for you:

   sudo sed -i "s/#password_encryption.*/password_encryption = scram-sha-256/"  /var/lib/pgsql/data/postgresql.conf

7. Start the database using the following command that also ensures that the database restarts in case the host restarts:

   sudo systemctl enable --now postgresql

8. Ensure the database is running:

   sudo systemctl status postgresql

9. Create the database user accounts. For example:

   sudo su - postgres -c "createuser -S -P pulp"

10. Enter and confirm the password for the pulp user.

    Enter password for new role: 
    Enter it again: 
    

11. Create the database.

    sudo su - postgres -c "createdb -O pulp pulp"

12. As the root user, in the /var/lib/pgsql/data/pg_hba.conf file add the following line:

    host  all  all 0.0.0.0/0 scram-sha-256

13. As the root user, in the /var/lib/pgsql/data/postgresql.conf file in the # CONNECTIONS AND AUTHENTICATION section, a line with the text listen_addresses = followed by the IP address or host name of the database in single quotes. For example:

    listen_addresses = '<IP address or host name>'
    
    #listen_addresses = 'localhost'         # what IP address(es) to listen on;
                                            # comma-separated list of addresses;
                                            # defaults to 'localhost'; use '*' for all
                                            # (change requires restart)
    #port = 5432                            # (change requires restart)

    In the previous example, <IP address or hostname> is the IP address or host name of the database.

14. Calculate and update the memory requirements parameters using the following:

    max_connections = 1024
    shared_buffers = total_mem_mb*0.3
    work_mem = total_mem_mb*0.03
    maintenance_work_mem = total_mem_mb*0.04

    In the previous example, total_mem_mb is the total memory size in megabytes of the system hosting the database server. For example, if the total available memory on the system were 18 000 MB, then this worksheet would include the following:

    max_connections = 1024
    shared_buffers = 18000*0.3
    work_mem = 18000*0.03
    maintenance_work_mem = 18000*0.04

    The final numbers to add are as follows:

    max_connections = 1024
    shared_buffers = 5400MB
    work_mem = 540MB
    maintenance_work_mem = 720MB

15. Add the calculated values to the /var/lib/pgsql/data/postgresql.conf file.
16. Restart the database.

    sudo systemctl restart postgresql

17. You're now ready to set up hosts as described in Installing on a Single Host.

This section provides instructions for installing the Private Automation Hub on a single host where the database is local or on a remote host and assumes that you have setup a passwordless SSH connection.

To set up the host:

1. On the deployment host, login as the user configured with Passwordless SSH to the target host. For more information, see Set Up Passwordless SSH.
2. Ensure python 3.6 is installed on your host. If python 3.6 isn't installed, run the following command:

   sudo dnf install python36

3. Install the Private Automation Hub software:

   sudo dnf install ol-private-automation-hub-installer
           

4. Copy the contents of the /single-node folder to a working directory.

   cp -r /usr/share/ansible/collections/ansible_collections/oraclelinux/private_automation_hub/playbooks/single-node/ ~/single_node

5. From the working directory, create a hosts file from the hosts.singlenode.example. For example,

   cd ~/single_node
   cp hosts.singlenode.example hosts

6. Edit the hosts file as follows:

   all:
     hosts:
       hub:
         ansible_host: <ip_address_or_hostname>
         ansible_user: <username>

   In the previous example,

   • <ip_address_or_hostname> is the IP address or host name of the target node where you want to install Private Automation Hub. This host must be reachable using SSH from the deployment host.

     Note:

     Valid characters for hostnames are a to z, 0 to 9, and the hyphen (-). A hostname may not start with a hyphen.
   • <username> is the username running the installer playbook commands on the target node where you want to install Private Automation Hub. This user must have sudo privileges.
7. To configure other installation parameters to use during the installation, setup the installation parameter file as described in Configuring the Installation Parameter File.
8. Do one of the following:
   • To install a local database on the same host running Private Automation Hub, run the following command:

     ansible-playbook single-node-install.yml -i hosts -e "olpah_admin_password=<admin_password> olpah_db_password=<db_password>"

     In the previous example, <admin_password> and <db_password> are the passwords for the default admin user and the database user account.

     Note:

     To use the parameter file, add the following to the end of the command:

     -e "@single-node-vars.yml"

   • To use an existing database on a remote host, run the following command:
     1. Log into the remote database.
     2. Install the following database extension.

        sudo dnf install postgresql-contrib

     3. Restart the database.

        sudo systemctl restart postgresql

     4. Create the database user accounts. For example:

        sudo su - postgres -c "createuser -S -P pulp"

     5. Enter and confirm the password for the pulp user.

        Note:

        This must be the same <db_password> as specified in the previous step.

        Enter password for new role: 
        Enter it again: 

     6. Create the database instance. For example:

        sudo su - postgres -c "createdb -O pulp pulp"

     7. From the single-node-install.yml file, remove the pulp_database role.
     8. Set the database hostname or IP address for the remote database (existing_db_host: <db_hostname_or_ip_address>) in the "@single-node-vars.yml" variables file. For more information about installing using the parameter file, see Configuring the Installation Parameter File.
     9. Return to the deployment server and run the following command:

        ansible-playbook single-node-install.yml -i hosts -e "olpah_admin_password=<admin_password> olpah_db_password=<db_password>" -e "@single-node-vars.yml"

        In the previous example, <admin_password> and <db_password> are the passwords for the default admin user and the database user account.
9. The host is now ready. Using a browser, you can now log in as the admin user.

   https://<ip_address_or_hostname>