This role installs and configures a postgresql server, or add new databases and user to an existing installation
This role requires Ansible 1.4 or higher and platform requirements are listed in the metadata file.
The variables that can be passed to this role and a brief description about them are as follows.
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
- name: database_name2
users:
- user: user_name1
password: user_password
privileges: ALL
type: database
-
Install postgresql without adding databases:
- { role: repleo.postgresql }
-
Install postgresql and add two databases:
- { role: repleo.postgresql, databases: [ { name: testdb1, users:[] }, { name: testdb2, users:[] } ] }
-
Install postgresql, add two databases, and configure database users per database:
- { role: repleo.postgresql,
databases: [ { name: testdb, users: [ { user: testuser1, password: 12345, privileges: ALL, type: database }, { user: testuser2, password: 12345, privileges: ALL, type: database }, ] } ] }
- { role: repleo.postgresql,
None.
GPL v3 - (c) 2016, Repleo, Amstelveen
Repleo, Amstelveen, Holland -- www.repleo.nl
Jeroen Arnoldus (jeroen@repleo.nl)