evolix/ansible-roles
22
2
Fork 2
Code Issues 61 Pull requests 18 Releases 33 Wiki Activity
ansible-roles/postgresql
History
Mathieu Trossevin 7c632352a0
Replace the include module with include_tasks or import_tasks 
The behaviour of the `include` module is badly defined (it try to choose
between statically importing the tasks and dynamically including them)
and can cause problems depending on any number of constraints (mostly if
it choose the wrong behaviour).

Replace it with the `import_tasks` (always statically import tasks) unless
the `include` is in a loop in which case we replace it with
`include_tasks` (always dynamically include tasks).
2023-01-03 14:43:42 +01:00
..
defaults Use proper keyrings directory for APT version 2022-11-02 23:16:32 +01:00
files postgresql: logrotate with dateext and right permissions 2023-01-03 10:56:19 +01:00
handlers Use systemd module instead of command 2022-12-28 09:02:17 +01:00
meta Update Galaxy metadata (company, platforms and galaxy_tags) 2021-06-28 15:26:28 +02:00
tasks Replace the include module with include_tasks or import_tasks 2023-01-03 14:43:42 +01:00
templates Proper jinja spacing 2022-12-28 09:03:37 +01:00
tests Improve Ansible syntax 2021-05-09 23:06:42 +02:00
.kitchen.yml Kitchen: Change base image to evolix/ansible 2017-06-02 08:38:08 -04:00
README.md Improve documentation 2017-01-05 18:22:06 +01:00

README.md

PostgreSQL

Installation and basic configuration of PostgreSQL.

Tasks

Tasks are in several files, included in tasks/main.yml :

  • packages.yml : packages installation ;
  • config.yml : configurations ;
  • nrpe.yml : nrpe user for Nagios checks ;
  • munin.yml : Munin plugins ;
  • logrotate.yml : logrotate configuration.

Available variables

Main variables are :

  • postgresql_databases: list of databases for Munin plugins
  • postgresql_shared_buffers: (default: 4GB)
  • postgresql_work_mem: (default: 8MB)
  • postgresql_random_page_cost: (default: 1.5)
  • postgresql_effective_cache_size: (default: 14GB)

The full list of variables (with default values) can be found in defaults/main.yml.