Process

ANSIBLE_LIBRARY=<path to Ansible4IOM>/modules/ \
ANSIBLE_ROLES_PATH=<path to Ansible4IOM>/roles/ \
ansible-playbook -i <path to inventory file>/inventory <path to Ansible4IOM>/processes/setup_omsdb.yml

Steps

The process consists of the following steps:

1. pgrepo_install
   1. Install PostgreSQL repository.
2. pgclient_install
   1. Install PG client yum package.
3. omsdb_initialization
   1. Create/update DB user.
   2. Create/update database.

Background Information

This process is separated from Process - Setup Postgres Server 1.0, in order to support usage of "DB-server as service". Nevertheless, access to the DB is required by a DB-user, who has sufficient permissions to create and configure a new DB account. The separation from Process - Setup Postgres Server 1.0 makes it necessary that the current process has to use its own configuration and cannot simply take over the configuration from the PostgreSQL-server installation. For the same reason, this process runs on application server machines, instead of a database server host.

All variables defining connection to the DB have to be set in the inventory. All information about the account to be prepared are taken from the OMS configuration. Please see roles/omsdb_config/defaults for details.

Examples

Initialize/ Reconfigure Database Account After Installing PostgreSQL-server.

In this case, the inventory has to contain information about the DB-server and the DB-account. Most information can be taken over directly from the PostgreSQL-server configuration, except the hostname, which is only implicitly available by assignment to group pg_server.

...
[all:vars]

# control setup of PostgreSQL-server
PGSERVER_PORT=5432
PGSERVER_SUPERUSER="postgres"
PGSERVER_SUPERUSER_PASSWD="s3cr3t"
 
# control setup of IOM DB account
OMSDB_HOST=db.your-private.net
OMSDB_PORT={{PGSERVER_PORT}}
OMSDB_SUPERUSER="{{PGSERVER_SUPERUSER}}"
OMSDB_SUPERUSER_PASSWD="{{PGSERVER_SUPERUSER_PASSWD}}"

Using this configuration, the DB-account can be created by executing the following command.

ANSIBLE_LIBRARY=<path to Ansible4IOM>/modules/ ANSIBLE_ROLES_PATH=<path to Ansible4IOM>/roles/ ansible-playbook -i <path to inventory file> <path to Ansible4IOM>/processes/setup_omsdb.yml