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

sysctl_file required? #6

Open
landam opened this issue Nov 25, 2017 · 0 comments
Open

sysctl_file required? #6

landam opened this issue Nov 25, 2017 · 0 comments

Comments

@landam
Copy link

landam commented Nov 25, 2017

When playing with ansible pg tune I got following error:

fatal: [gislab_vagrant]: FAILED! => {"changed": false, "failed": true,
"module_stderr": "Shared connection to 127.0.0.1 closed.\r\n",
"module_stdout": "Traceback (most recent call last):\r\n  File
\"/tmp/ansible_p6EVdJ/ansible_module_postgresql_tune.py\", line 374,
in <module>\r\n    main()\r\n  File
\"/tmp/ansible_p6EVdJ/ansible_module_postgresql_tune.py\", line 369,
in main\r\n    has_changed, config = tune(module.params)\r\n  File
\"/tmp/ansible_p6EVdJ/ansible_module_postgresql_tune.py\", line 332,
in tune\r\n    with open(data[\"sysctl_file\"], 'w') as
confile:\r\nTypeError: coercing to Unicode: need string or buffer,
NoneType found\r\n", "msg": "MODULE FAILURE", "rc": 0}

In documentation (1) is set sysctl_file param only for PG 9.1 (but, even in the vars, version 9.6 is mentioned). The ansible playbook was run against PG 9.5. It's not clear when sysctl_file is required (2).

See probably related #5.

(1) https://github.com/imincik/ansible-postgresql_tune#postgres-91-with-changes-to-kernel-shm-settings-and-setting-a-max_connections
(2) https://github.com/imincik/ansible-postgresql_tune#postgresql-96

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

1 participant