summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--files/etc/postgresql/postgresql.conf4
-rw-r--r--tasks/webmap.yml7
2 files changed, 11 insertions, 0 deletions
diff --git a/files/etc/postgresql/postgresql.conf b/files/etc/postgresql/postgresql.conf
new file mode 100644
index 0000000..038438a
--- /dev/null
+++ b/files/etc/postgresql/postgresql.conf
@@ -0,0 +1,4 @@
+shared_buffers = 768MB
+temp_buffers = 128MB
+work_mem = 16MB
+effective_cache_size = 1536MB
diff --git a/tasks/webmap.yml b/tasks/webmap.yml
index 5f82d7f..a417dbd 100644
--- a/tasks/webmap.yml
+++ b/tasks/webmap.yml
@@ -165,6 +165,13 @@
# PostgreSQL needs to be restarted to see the new locale
notify: Restart PostgreSQL
+- name: Configure PostgreSQL
+ copy: src=etc/postgresql/postgresql.conf
+ dest=/etc/postgresql/{{ postgresql.version }}/{{ postgresql.cluster }}/conf.d/local.conf
+ owner=postgres group=postgres
+ mode=0644
+ notify: Restart PostgreSQL
+
- name: Start PostgreSQL
service: name=postgresql@{{ postgresql.version }}-{{ postgresql.cluster }}.service state=started