vertica_facts – Gathers Vertica database facts

From Get docs
Ansible/docs/2.8/modules/vertica facts module


vertica_facts – Gathers Vertica database facts

New in version 2.0.


Synopsis

  • Gathers Vertica database facts.

Requirements

The below requirements are needed on the host that executes this module.

  • unixODBC
  • pyodbc

Parameters

Parameter Choices/Defaults Comments

cluster

-

Default:

"localhost"

Name of the cluster running the schema.

db

-

Name of the database running the schema.

login_password

-

The password used to authenticate with.

login_user

-

Default:

"dbadmin"

The username used to authenticate with.

port

-

Default:

5433

Database port to connect to.



Notes

Note

  • The default authentication assumes that you are either logging in as or sudo’ing to the dbadmin account on the host.
  • This module uses pyodbc, a Python ODBC database adapter. You must ensure that unixODBC and pyodbc is installed on the host and properly configured.
  • Configuring unixODBC for Vertica requires Driver = /opt/vertica/lib64/libverticaodbc.so to be added to the Vertica section of either /etc/odbcinst.ini or $HOME/.odbcinst.ini and both ErrorMessagesPath = /opt/vertica/lib64 and DriverManagerEncoding = UTF-16 to be added to the Driver section of either /etc/vertica.ini or $HOME/.vertica.ini.


Examples

- name: gathering vertica facts
  vertica_facts: db=db_name

Status

Authors

  • Dariusz Owczarek (@dareko)

Hint

If you notice any issues in this documentation you can edit this document to improve it.


© 2012–2018 Michael DeHaan
© 2018–2019 Red Hat, Inc.
Licensed under the GNU General Public License version 3.
https://docs.ansible.com/ansible/2.8/modules/vertica_facts_module.html