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

This module is flagged as preview which means that it is not guaranteed to have a backwards compatible interface.

Maintenance

This module is flagged as community which means that it is maintained by the Ansible Community. See Module Maintenance & Support for more info.

For a list of other modules that are also maintained by the Ansible Community, see here.

Author

• Dariusz Owczarek (@dareko)

Hint

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