postgresql plugin does not produce working database configuration with writer query

[ph448]

Affected Puppet, Ruby, OS and module versions/distributions

• Puppet: 6.22.1
• Ruby: 2.7
• Distribution: Ubuntu
• Module version: v12.2.0

How to reproduce (e.g Puppet code you use)

Please note I'm synthesizing this as my code uses YAML data and the splat operator to create resources

collectd::plugin::postgresql::database{'metrics':
  name     => 'metrics',
  port     => '5432',
  host     => 'metricshost',
  user     => 'metrics',
  password => 'collectd',
  writer   => 'sqlstore',
  interval => 10,
}
collectd::plugin::postgresql::writer{'sqlstore':
  statement  => 'SELECT collectd_insert($1, $2, $3, $4, $5, $6, $7, $8, $9);',
  storerates => 'true',
}

What are you seeing

The manifest using collectd::plugin::postgresql::database runs successfully, but the created file contains

Interval 10

and metrics are only committed once on program startup.

What behaviour did you expect instead

The template should emit

CommitInterval 10

for the plugin to regularly commit collected values.