June
9662995377
Add postgresql role for ensuring postgresql is installed. Furthermore the role optionally takes some basic configuration to ensure databases with their owners and users are set up as specified. This is a requirement for a new netbox role.
37 lines
1.1 KiB
Markdown
37 lines
1.1 KiB
Markdown
# Role `postgresql`
|
|
|
|
Ensures `postgresql` is installed by installing the distributions package.
|
|
Also ensures the optionally given databases and users are set up as specified.
|
|
|
|
## Supported Distributions
|
|
|
|
Should work on Debian-based distributions.
|
|
|
|
## Required Arguments
|
|
|
|
None.
|
|
|
|
## Optional Arguments
|
|
|
|
- `postgresql__dbs`: List of databases with their owner to ensure are set up.
|
|
- `postgresql__dbs.*.name`: Name of the database.
|
|
- `postgresql__dbs.*.owner`: Owner of the database.
|
|
- `postgresql__users`: List of users to ensure are set up.
|
|
- `postgresql__users.*.name`: Name of the user.
|
|
- `postgresql__users.*.password`: Optional password for the user.
|
|
If left unset, the user will have no password set, but can still connect using [peer authentication](https://www.postgresql.org/docs/current/auth-peer.html) on the local system.
|
|
(Peer authentication works when a password is set as well.)
|
|
|
|
## Example Arguments
|
|
|
|
```yaml
|
|
postgresql__dbs:
|
|
- name: netbox
|
|
owner: netbox
|
|
- name: foo
|
|
owner: bar
|
|
postgresql__users:
|
|
- name: netbox
|
|
password: super_secret
|
|
- name: bar
|
|
```
|