repleo.postgresql

Ansible Role - Postgresql Database Installation Role

This role helps you install and set up a PostgreSQL server. You can also use it to create new databases and users on an existing server.

Requirements

To use this role, you need Ansible version 1.4 or higher. The specific platform requirements can be found in the metadata file.

Role Variables

Here are the variables you can use with this role, along with a short description:

databases: This is a list of databases you want to create. Each database can have associated users with specific privileges.

Example:

databases:
  - name: database_name1
    users:
      - user: user_name1
        password: user_password
        privileges: ALL
        type: database
      - user: user_name2
        password: user_password
        privileges: ALL
        type: database

Examples

Install PostgreSQL without any databases:

- { role: repleo.postgresql }

Install PostgreSQL and create two empty databases:

- { role: repleo.postgresql,
      databases: [
       { name: testdb1, users: [] },
       { name: testdb2, users: [] }
      ]
}

Install PostgreSQL, create two databases, and set up users for the first database:

- { role: repleo.postgresql,         
      databases: [
        { name: testdb,
          users: [
            { user: testuser1,
              password: 12345,
              privileges: ALL,
              type: database },
            { user: testuser2,
              password: 12345,
              privileges: ALL,
              type: database },
          ]
        }
      ]
}