New in version 2.0.
The below requirements are needed on the host that executes this module.
unixODBC
pyodbc
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.
|
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
vertica_configuration: name=failovertostandbyafter value='8 hours'
This module is not guaranteed to have a backwards compatible interface. [preview]
This module is maintained by the Ansible Community. [community]
Dariusz Owczarek (@dareko)
Hint
If you notice any issues in this documentation you can edit this document to improve it.