aboutsummaryrefslogtreecommitdiffstats
path: root/roles/postgresql_server/README.md
diff options
context:
space:
mode:
authorStonewall Jackson <stonewall@sacredheartsc.com>2023-02-16 21:25:56 -0500
committerStonewall Jackson <stonewall@sacredheartsc.com>2023-02-16 21:25:56 -0500
commit76dbd6310861346983006cdcb20aa76a37a1df75 (patch)
treea12f5acec0123ce0a5f793184cd652eb94b6ea71 /roles/postgresql_server/README.md
parent3ed6b9aec1168488e22c910fcabe6ff0f3cb34c2 (diff)
downloadselfhosted-76dbd6310861346983006cdcb20aa76a37a1df75.tar.gz
selfhosted-76dbd6310861346983006cdcb20aa76a37a1df75.zip
postgresql_server: add docs
Diffstat (limited to 'roles/postgresql_server/README.md')
-rw-r--r--roles/postgresql_server/README.md36
1 files changed, 36 insertions, 0 deletions
diff --git a/roles/postgresql_server/README.md b/roles/postgresql_server/README.md
new file mode 100644
index 0000000..493bdb0
--- /dev/null
+++ b/roles/postgresql_server/README.md
@@ -0,0 +1,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
+ hosts: postgresql_servers
+ roles:
+ - role: postgresql
+ vars:
+ postgresql_password_users:
+ - invidious
+ - mydbuser
+````