Code Monkey home page Code Monkey logo

ansible-postgresql-on-el6's Introduction

README: install-postgresql-on-el

Features:

  • supported distributions: 6 and 7 versions of Redhat, CentOS, Scientific Linux.
  • Oracle Linux also supported but uses RHEL repositories.
  • supported PostgreSQL versions: 8.4, 9.0, 9.1, 9.2, 9.3, 9.4.
  • allows specify users 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 /var/lib/pgsql/x.y/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.

Todo:

How-to use:

  • download repo with git clone;
  • cd into role directory;
  • change hosts: variable in role.yml;
  • start ansible-playbook with role.yml and your inventory file.
ansible-playbook -i /etc/ansible/staging role.yml

ansible-postgresql-on-el6's People

Contributors

lesovsky avatar programmer-ke avatar sergiosdlima avatar

Stargazers

avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar

Watchers

avatar avatar avatar avatar avatar

Forkers

mageru dlip desmax74 sergiosdlima jason-lanpher phoenixtheii jcapitao cscfi programmer-ke just4est korderao boonchu msmarnaoui jbijoux adhanowa ascii1011 litvin reslavath gridl predoiua funkypenguin18 vinayjaiswal1990 itex77

ansible-postgresql-on-el6's Issues

fatal error while evaluating conditional: item.version == "9.4"

I added the lesovsky.postgresql-on-el6 role in my playbook, but this is causing an error, see:

TASK: [lesovsky.postgresql-on-el6 | Stage 1: install repository package] ******
fatal: [institucional] => error while evaluating conditional: item.version == "9.4"

Error running on Ansible v2

After upgrading to Ansible (2.0.1.0) I'm unable to get past Stage 1:

TASK [postgresql : Stage 1: install repository package] ************************
fatal: [axiom]: FAILED! => {"failed": true, "msg": "'str object' has no attribute 'repo'"}
to retry, use: --limit @webservers.retry

- name: "Stage 1: install repository package" yum: state: present pkg: "{{ item.repo }}" when: item.version == "{{ postgresql_version }}" with_items: postgresql_repo_{{ ansible_distribution }} tags: - postgresql

From what I can tell it isn't expanding the postgresql_repo_{{ ansible_distribution }} variable properly. If I hard code the variable name to 'postgresql_repo_CentOS' the play works.

replay the roole with error "msg": "error: noting to do\n",

Ever second,third,... time i play the role i have the following error.
if the packed pgdg-centos94-9.4-1.noarch.rpm is already installed.

Here is the error in german...

{
  "changed": true,
  "item": {
    "repo": "http://yum.postgresql.org/9.4/redhat/rhel-7-x86_64/pgdg-centos94-9.4-1.noarch.rpm",
    "version": "9.4"
  },
  "rc": 1,
  "msg": "Fehler: Nichts zu tun\n",
  "play": "thingworx",
  "task": "Stage 1: install repository package",
  "role": "ansible-postgresql-on-el6",
  "ignore_errors": false,
  "status": "failed",
  "stdout": "Geladene Plugins: fastestmirror\n/var/tmp/yum-root-mux6vt/pgdg-centos94-9.4-1.noarch.rpm wird untersucht: pgdg-centos94-9.4-1.noarch\n/var/tmp/yum-root-mux6vt/pgdg-centos94-9.4-1.noarch.rpm: aktualisiert installierte Pakete nicht.\n\n",
  "module_name": "yum",
  "module_args": "",
  "created": "2016-01-26T12:40:15.288Z",
  "host_id": 87,
  "host_name": "backend",
  "id": 35056,
  "parent": 35054,
  "event": "Host Failed"
}
 Prev NextOK

Return Code: 1
Message: Fehler: Nichts zu tun
ignore_errors: false

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.