Skip to content

lesovsky/ansible-postgresql-sr-on-el6

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

README: install PostgreSQL and configure Streaming Replication

Features:

  • based on postgresql-on-el6 role.
  • supported distributions:
    • RedHat, CentOS, Scientific Linux version 6 and 7
    • Oracle Linux also supported but uses RHEL repositories
    • Debian 8
    • Ubuntu 14.04
  • supported PostgreSQL versions: 9.0, 9.1, 9.2, 9.3, 9.4.
  • allows specify users, and dedicated replication user and databases which would be created after install.
  • ability to determine a set of postgresql.conf parameters and absense postgresql.conf template. Template is not used due to the fact that the postgresql.conf differs from version to version on a set of parameters.
  • ability to specify another cluster directory and setup symlink into original data location.
  • ability to specify extension list for created databases (only for versions >= 9.0).

Known issues:

  • RHEL 6: packages from pgdg repo does not install due to repo configuration parsing error. Workaround: replace $releasever variable to your specific release version. This issue does not occurs on the others distributions.
  • RHEL 6: posqtgresqlXY-contrib doesn't install due to dependency error. In my case, this may be caused by the use of an unregistered RedHat distribution and unofficial third-party repositories. On the Oracle Enterprise Linux this issue does not occur.

How-to use:

  • download repo with git clone;
  • cd into role directory;
  • specify master and slaves ip addresses in inventory file;
  • specify master and slaves ip addresses and other configuration in defaults/main.yml file;
  • change hosts: variable in role.yml;
  • start ansible-playbook with role.yml and your inventory file.
ansible-playbook -i inventory role.yml

About

Install PostgreSQL and configure streaming replication on EL6

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published