ansible-debops-infrastructure

DebOps and Ansible scripts to manage my infrastructure
git clone git://git.erethon.com/ansible-debops-infrastructure
Log | Files | Refs

commit a187dad60444a6fdbfbf533b129165ff581ff24c
parent de61af8c5e47830beb46d1412f21e66de107e43f
Author: Dionysis Grigoropoulos <dgrig@erethon.com>
Date:   Sun, 26 Jan 2020 01:03:28 +0200

postgresmatrix: Add Postgresql related settings

Diffstat:
ansible/inventory/host_vars/postgresmatrix/postgresql_server.yml | 23+++++++++++++++++++++++
1 file changed, 23 insertions(+), 0 deletions(-)

diff --git a/ansible/inventory/host_vars/postgresmatrix/postgresql_server.yml b/ansible/inventory/host_vars/postgresmatrix/postgresql_server.yml @@ -0,0 +1,23 @@ +--- + +postgresql_server__listen_addresses: [ "{{ hostvars[inventory_hostname].ansible_host }}" ] +postgresql_server__allow: [ "{{ hostvars['productionmatrix'].ansible_host }}" ] + +postgresql_server__cluster_main: + name: 'main' + port: '5432' + shared_buffers: "256MB" + work_mem: "655kB" + maintenance_work_mem: "64MB" + effective_io_concurrency: 200 + wal_buffers: "7864kB" + checkpoint_completion_target: 0.7 + random_page_cost: 1.1 + effective_cache_size: "768MB" + + hba: + - type: 'host' + database: 'synapse' + user: 'synapse' + address: [ "{{ hostvars['productionmatrix'].ansible_host }}/32" ] + method: 'md5'