community.general.vertica_info (1.3.11) — module

Install collection

Install with ansible-galaxy collection install community.general:==1.3.11

Add to requirements.yml

  collections:
    - name: community.general
      version: 1.3.11

Description

Gathers Vertica database information.

This module was called C(vertica_facts) before Ansible 2.9, returning C(ansible_facts). Note that the M(community.general.vertica_info) module no longer returns C(ansible_facts)!

Requirements

• unixODBC
• pyodbc

Usage examples

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Gathering vertica facts
  community.general.vertica_info: db=db_name
  register: result

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Print schemas
  ansible.builtin.debug:
    msg: "{{ result.vertica_schemas }}"

Inputs

    
db:
    description:
    - Name of the database running the schema.
    type: str

port:
    default: 5433
    description: Database port to connect to.
    type: str

cluster:
    default: localhost
    description:
    - Name of the cluster running the schema.
    type: str

login_user:
    default: dbadmin
    description:
    - The username used to authenticate with.
    type: str

login_password:
    description:
    - The password used to authenticate with.
    type: str