community.general.vertica_info (8.5.0) — module

Install collection

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

Add to requirements.yml

  collections:
    - name: community.general
      version: 8.5.0

Description

Gathers Vertica database information.

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