vertica_configuration - Updates Vertica configuration parameters.
New in version 2.0.
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 thatunixODBC
andpyodbc
is installed on the host and properly configured. - Configuring
unixODBC
for Vertica requiresDriver = /opt/vertica/lib64/libverticaodbc.so
to be added to theVertica
section of either/etc/odbcinst.ini
or$HOME/.odbcinst.ini
and bothErrorMessagesPath = /opt/vertica/lib64
andDriverManagerEncoding = UTF-16
to be added to theDriver
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 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.
© 2012–2018 Michael DeHaan
© 2018–2019 Red Hat, Inc.
Licensed under the GNU General Public License version 3.
https://docs.ansible.com/ansible/2.6/modules/vertica_configuration_module.html