Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Not working with postgresql 9.5 #50

Open
joba12 opened this issue Apr 13, 2016 · 1 comment
Open

Not working with postgresql 9.5 #50

joba12 opened this issue Apr 13, 2016 · 1 comment

Comments

@joba12
Copy link

joba12 commented Apr 13, 2016

Works pretty fine with psql 9.4 on CentOS 7.2, but not with 9.5

Following error while running the playbook:

RUNNING HANDLER [patrik.uytterhoeven.PostgreSQL-For-RHEL6x : restart postgresql] ***
fatal: [localhost]: FAILED! => {"changed": false, "failed": true, "msg": "Job for postgresql-9.5.service failed because the control process exited with error code. See \"systemctl status postgresql-9.5.service\" and \"journalctl -xe\" for details.\n"}
        to retry, use: --limit @playbooks/database/main.retry

PLAY RECAP *********************************************************************
localhost                  : ok=23   changed=15   unreachable=0    failed=1
systemctl status postgresql-9.5.service
● postgresql-9.5.service - PostgreSQL 9.5 database server
   Loaded: loaded (/etc/systemd/system/postgresql-9.5.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Wed 2016-04-13 07:51:19 CEST; 14s ago
  Process: 6342 ExecStart=/usr/pgsql-9.5/bin/pg_ctl start -D ${PGDATA} -s -w -t 300 (code=exited, status=1/FAILURE)
  Process: 6336 ExecStartPre=/usr/pgsql-9.5/bin/postgresql95-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)

Apr 13 07:51:18 nlihmoodle01.hosting.local systemd[1]: Starting PostgreSQL 9.5 database server...
Apr 13 07:51:18 nlihmoodle01.hosting.local pg_ctl[6342]: **LOG:  unrecognized configuration parameter "checkpoint_segments" in file "/var/lib/pgsql/9.5/data/postgresql.conf" line 161**
Apr 13 07:51:18 nlihmoodle01.hosting.local pg_ctl[6342]: **FATAL:  configuration file "/var/lib/pgsql/9.5/data/postgresql.conf" contains errors**
Apr 13 07:51:19 nlihmoodle01.hosting.local pg_ctl[6342]: pg_ctl: could not start server
Apr 13 07:51:19 nlihmoodle01.hosting.local pg_ctl[6342]: Examine the log output.
Apr 13 07:51:19 nlihmoodle01.hosting.local systemd[1]: postgresql-9.5.service: control process exited, code=exited status=1
Apr 13 07:51:19 nlihmoodle01.hosting.local systemd[1]: Failed to start PostgreSQL 9.5 database server.
Apr 13 07:51:19 nlihmoodle01.hosting.local systemd[1]: Unit postgresql-9.5.service entered failed state.
Apr 13 07:51:19 nlihmoodle01.hosting.local systemd[1]: postgresql-9.5.service failed.

Playbook:

  roles:
    - patrik.uytterhoeven.PostgreSQL-For-RHEL6x
  vars:
      postgresql_version: 9.5
      postgresql_admin_user: "postgres"
      postgresql_default_auth_method: "trust"
@Trikke76
Copy link
Contributor

This is probably due to a parameter in the template that has been changed in 9.5
the template is not the best solution
what i want to do in the future is remove the template and make use of lineinfile this would make upgrading to a new version of postgres more easy but it will take a huge amount of time.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants