community.general.vertica_configuration – Updates Vertica configuration parameters.

Note

This plugin is part of the community.general collection (version 1.3.2).

To install it use: ansible-galaxy collection install community.general.

To use it in a playbook, specify: community.general.vertica_configuration.

Synopsis

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

Parameter	Choices/Defaults	Comments
cluster string	Default: "localhost"	Name of the Vertica cluster.
db string		Name of the Vertica database.
login_password string		The password used to authenticate with.
login_user string	Default: "dbadmin"	The username used to authenticate with.
name string / required		Name of the parameter to update. aliases: parameter
port string	Default: "5433"	Vertica cluster port to connect to.
value string		Value of the parameter to be set.

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.

- name: Updating load_balance_policy
  community.general.vertica_configuration: name=failovertostandbyafter value='8 hours'

© 2012–2018 Michael DeHaan
© 2018–2019 Red Hat, Inc.
Licensed under the GNU General Public License version 3.
https://docs.ansible.com/ansible/2.10/collections/community/general/vertica_configuration_module.html