The module used to manage the postgresql database (puppetlabs-postgresql[1]) only supports to manage a single postgresql instance (more details on T2736).
It's not enough for our usages as for database servers, we have 3 clusters, 1 for the main storage, 1 for the secondary databases (scheduler, lister, ...) and 1 for the indexer.

We need to have a module that support such configuration

[1] https://github.com/puppetlabs/puppetlabs-postgresql#contributors version v6.4.0