New in version 1.7.
|cascade ||no|| || |
when dropping a language, also delete object that depend on this language.
only used when
|db ||no|| |
name of database where the language will be added, removed or changed
|fail_on_drop ||no||yes|| || |
in some cases, it is not possible to remove a language (used by the db-system). When dependencies block the removal, consider using
|force_trust ||no|| || |
marks the language as trusted, even if it's marked as untrusted in pg_pltemplate.
use with care!
|lang ||yes|| |
name of the procedural language to add, remove or change
|login_host ||no||localhost|| |
Host running PostgreSQL where you want to execute the actions.
|login_password ||no|| |
Password used to authenticate with PostgreSQL (must match
|login_user ||no||postgres|| |
User used to authenticate with PostgreSQL
|port ||no||5432|| |
Database port to connect to.
|state ||no||present|| || |
The state of the language for the selected database
|trust ||no|| || |
make this language trusted for the selected db
# Add language pltclu to database testdb if it doesn't exist: - postgresql_lang db=testdb lang=pltclu state=present # Add language pltclu to database testdb if it doesn't exist and mark it as trusted: # Marks the language as trusted if it exists but isn't trusted yet # force_trust makes sure that the language will be marked as trusted - postgresql_lang: db: testdb lang: pltclu state: present trust: yes force_trust: yes # Remove language pltclu from database testdb: - postgresql_lang: db: testdb lang: pltclu state: absent # Remove language pltclu from database testdb and remove all dependencies: - postgresql_lang: db: testdb lang: pltclu state: absent cascade: yes # Remove language c from database testdb but ignore errors if something prevents the removal: - postgresql_lang: db: testdb lang: pltclu state: absent fail_on_drop: no
This module is flagged as preview which means that it is not guaranteed to have a backwards compatible interface.
© 2012–2017 Michael DeHaan
© 2017 Red Hat, Inc.
Licensed under the GNU General Public License version 3.