aboutsummaryrefslogtreecommitdiffstats
path: root/roles/postgresql_server/README.md
blob: 8e01775e37186161dd10fcac4bc9b821479e511f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
PostgreSQL Server
=================

Description
-----------

The `postgresql_server` role installs and configures the PostgreSQL database,
and configures the server for client GSSAPI authentication.

Variables
---------

This role **accepts** the following variables:

Variable                         | Default          | Description
---------------------------------|------------------|------------
`postgresql_timezone`            | `{{ timezone }}` | Database timezone
`postgresql_max_connections`     | 100              | Maximum number of concurrent connections
`postgresql_shared_buffers_mb`   | 25% of host RAM  | Shared buffer size (MB)
`postgresql_password_users`      | `[]`             | List of users that don't support GSSAPI authentication

Usage
-----

Example playbook:

````yaml
- name: configure postgresql database
  hosts: postgresql_servers
  roles:
    - role: postgresql
      vars:
        postgresql_password_users:
          - invidious
          - mydbuser
````