evolix
/
ansible-roles
15
2
Fork 1
Code Issues 53 Pull Requests 14 Releases 11 Wiki Activity
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.
2490 Commits
40 Branches
34 Tags
9.7 MiB
 
 
 
 
 
 
Branch: stable
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'stable'
${ noResults }
ansible-roles/postgresql
Jérémy Lecour f082cb652a
continuous-integration/drone/push Build is passing
Details
continuous-integration/drone/tag Build is passing
Details
postgresql: rename GPG key 		4 weeks ago
..
defaults add postgresql_version to empty 8 months ago
files postgresql: rename GPG key 4 weeks ago
handlers Set handler postgresql with systemctl daemon-reload 1 year ago
meta Update Galaxy metadata (company, platforms and galaxy_tags) 4 weeks ago
tasks postgresql: rename GPG key 4 weeks ago
templates Replace version_compare() with version() 1 year ago
tests Improve Ansible syntax 3 months ago
.kitchen.yml Kitchen: Change base image to evolix/ansible 4 years ago
README.md Improve documentation 5 years ago

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.