ansible.postgresql_db(3) - Linux man page

Name

postgresql_db - Add or remove PostgreSQL databases from a remote host.

Description

Add or remove PostgreSQL databases from a remote host.

Options

encoding

Encoding of the database
login_host: Host running the database (default: localhost)
login_password: The password used to authenticate with
login_user: The username used to authenticate with
name name of the database to add or remove(required) owner Name of the role to set as owner of the database state The database state Choices: present,absent. (default: present)
template: Template used to create the database."

Notes

The default authentication assumes that you are either logging in as or sudo'ing to the postgres account on the host.

This module uses psycopg2, a Python PostgreSQL database adapter. You must ensure that psycopg2 is installed on the host before using this module. If the remote host is the PostgreSQL server (which is the default case), then PostgreSQL must also be installed on the remote host. For Ubuntu-based systems, install the postgresql, libpq-dev, and python-psycopg2 packages on the remote host before using this module.

Examples

Create a new database with name acme

postgresql_db: db=acme

Author

Lorin Hochstein