On this page
vertica_configuration - Updates Vertica configuration parameters.
New in version 2.0.
Synopsis
- Updates Vertica configuration parameters.
Requirements (on host that executes module)
- unixODBC
- pyodbc
Options
parameter | required | default | choices | comments |
---|---|---|---|---|
cluster |
no | localhost |
Name of the Vertica cluster.
|
|
db |
no |
Name of the Vertica database.
|
||
login_password |
no |
The password used to authenticate with.
|
||
login_user |
no | dbadmin |
The username used to authenticate with.
|
|
name |
yes |
Name of the parameter to update.
|
||
port |
no | 5433 |
Vertica cluster port to connect to.
|
|
value |
yes |
Value of the parameter to be set.
|
Examples
- name: updating load_balance_policy
vertica_configuration: name=failovertostandbyafter value='8 hours'
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
.
Status
This module is flagged as preview which means that it is not guaranteed to have a backwards compatible interface.
For help in developing on modules, should you be so inclined, please read Community Information & Contributing, Testing Ansible and Developing Modules.
© 2012–2018 Michael DeHaan
© 2018–2019 Red Hat, Inc.
Licensed under the GNU General Public License version 3.
https://docs.ansible.com/ansible/2.4/vertica_configuration_module.html