Ansible roles by Evolix
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Eric Morino c324866cd2 Add set variables for debian stretch and jessie 1 month ago
defaults add postgresql_version to empty 1 month ago
files Fix logrotate configuration 10 months ago
handlers Set handler postgresql with systemctl daemon-reload 10 months ago
meta change repositories URL 1 year ago
tasks Add set variables for debian stretch and jessie 1 month ago
templates Override Unit systemd with OMkill less 10 months ago
tests apt module: Use "state: present" instead of "state: installed" 2 years ago
.kitchen.yml Kitchen: Change base image to evolix/ansible 3 years ago Improve documentation 4 years ago


Installation and basic configuration of PostgreSQL.


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.