New in version 1.7.
The below requirements are needed on the host that executes this module.
Parameter | Choices/Defaults | Comments |
---|---|---|
cascade bool |
| when dropping a language, also delete object that depend on this language. only used when state=absent . |
db | name of database where the language will be added, removed or changed | |
fail_on_drop bool |
| if yes , fail when removing a language. Otherwise just log and continuein some cases, it is not possible to remove a language (used by the db-system). When dependencies block the removal, consider using cascade . |
force_trust bool |
| marks the language as trusted, even if it's marked as untrusted in pg_pltemplate. use with care! |
lang required | name of the procedural language to add, remove or change | |
login_host | Default: localhost | Host running PostgreSQL where you want to execute the actions. |
login_password | Password used to authenticate with PostgreSQL (must match login_user ) | |
login_user | Default: postgres | User used to authenticate with PostgreSQL |
port | Default: 5432 | Database port to connect to. |
state |
| The state of the language for the selected database |
trust bool |
| make this language trusted for the selected db |
Note
# 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.
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.
Hint
If you notice any issues in this documentation you can edit this document to improve it.
© 2012–2018 Michael DeHaan
© 2018 Red Hat, Inc.
Licensed under the GNU General Public License version 3.
https://docs.ansible.com/ansible/2.7/modules/postgresql_lang_module.html