pgsql
pgsql
Provides four new ansible modules for Postgresql:
- postgresql_table: ensure that a table is present (or absent) in database
- postgresql_row: ensure that a row is present (or absent) in a table
- postgresql_query: execute an arbitrary query in database and return results
- postgresql_command: execute an arbitrary query in database
For additional docs look project's wiki: https://github.com/rtshome/ansible_pgsql/wiki
Requirements
It requires psycopg2 installed as per Ansible's PostgreSQL modules: http://docs.ansible.com/ansible/latest/list_of_database_modules.html#postgresql
Role Variables
No variables are defined by the module
Dependencies
Example Playbook
Sample playbook that:
- creates the table
config
inacme
database - ensures that a row is present in
config
table - performs a SELECT query on
config
and stores results inquery
var - execute a command removing all records in
logs
table
- hosts: servers
tasks:
- postgresql_table:
database: acme
name: config
state: present
columns:
- {
name: key,
type: text,
null: False
}
- {
name: value,
type: text,
null: False
}
primary_key:
- key
- postgresql_row:
database: acme
table: config
row:
key: env
value: production
- postgresql_query:
database: acme
query: SELECT * FROM config WHERE env = %(env)s
parameters:
env: production
register: query
- postgresql_command:
database: acme
command: "TRUNCATE logs"
roles:
- rtshome.pgsql
License
BSD
Author Information
Denis Gasparin denis@gasparin.net http://www.gasparin.net
About
Add four modules to interact with PostgreSQL DBMS: postgresql_table, postgresql_row, postgresql_query, postgresql_command.
Install
ansible-galaxy install rtshome/ansible_pgsql
License
bsd-2-clause
Downloads
68427
Owner