vertica_configuration – Updates Vertica configuration parameters

Synopsis

• Updates Vertica configuration parameters.

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 Vertica cluster.
db -		Name of the Vertica database.
login_password -		The password used to authenticate with.
login_user -	Default: "dbadmin"	The username used to authenticate with.
name - / required		Name of the parameter to update. aliases: parameter
port -	Default: 5433	Vertica cluster port to connect to.
value - / required		Value of the parameter to be set.

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: updating load_balance_policy
  vertica_configuration: name=failovertostandbyafter value='8 hours'

Status

• This module is not guaranteed to have a backwards compatible interface. [preview]
• This module is maintained by the Ansible Community. [community]

Authors

• Dariusz Owczarek (@dareko)

Hint

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