Process - Cleanup Database Account 1.1

Table of Contents

Product Version


Product To Version


New Labels

1 Process


The process cleanup_omsdb removes an existing database account. The process is intended to be used by CI processes or on preproduction systems, in order to reset a database back into initial state.


Never run this process on production systems, since all data will definitely be deleted.

Example: setup OMS DB account
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/cleanup_omsdb.yml

1.1 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_cleanup
    1. Delete database and DB user.

1.2 Background Information

The process cleanup_omsdb allows to remove IOM DB user and database from a PostgreSQL server. The process is controlled by variables defined in roles/omsdb_config/defaults. Please have a look into the according file, to get information about which variables are available.


The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.

Customer Support
Knowledge Base
Product Resources