Type: New Feature
Affects Version/s: None
Fix Version/s: None
CentOS 7 with Software Collection PostgreSQL 9.5
Template:MODULES Bug Template customfield_10700 185011
QA Risk Assessment:Needs Assessment
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.
Connection validation works
Connection validation fails