Document Properties
Kbid
28387E
Last Modified
08-Dec-2022
Added to KB
26-Jul-2017
Public Access
Everyone
Status
Online
Doc Type
References
Product
  • IOM 3.0
  • IOM 3.1
  • IOM 3.2
  • IOM 3.3
  • IOM 3.4
  • IOM 3.5
  • IOM 3.6
  • IOM 3.7
  • IOM 4.0
  • IOM 4.1
  • IOM 4.2
  • IOM 4.3
  • IOM 4.4
Process - Cleanup Database Account 1.0

Table of Contents

Product Version

2.2

Product To Version


Status

New Labels

Process

Description

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.

Warning

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

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.

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.

Disclaimer

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
Tickets