Details
-
New Feature
-
Status: Accepted
-
Normal
-
Resolution: Unresolved
-
None
-
None
-
CentOS 7 with Software Collection PostgreSQL 9.5
-
Modules
-
Needs Assessment
Description
Basic Info
Module Version: 4.9.0
Puppet Version: 4.10 (puppet-agent 1.10)
OS Name/Version: CentOS/RedHat Enterprise Linux 7
I've tried to install PuppetDB with PostgreSQL 9.5 from SoftwareCollections. This worked out mostly fine after i've figured out all postgresql::globals params.
Example puppet manifest: https://gist.github.com/vinzent/448fa47032a6f050fb4c501cc741ccad#file-puppetdb-postgresql-9-5-example-pp
The only missing failing class was postgresql::service with the Postgresql::Validate_db_connection['validate_service_is_running'] resource. It was missing the LD_LIBRARY_PATH environment variable.
I've edited manifests/server/service.pp so it passes postgresql::server::default_connect_settings as connect_settings param to this resource.
Proposed patch: https://gist.github.com/vinzent/448fa47032a6f050fb4c501cc741ccad#file-postgresql-service-validate_db_connection-patch
Desired Behavior:
Connection validation works
Actual Behavior:
Connection validation fails