[collectd] Not seeing postgres data from collectd.

[James Armstrong]

We're trying to add a monitor for some table sizes to collectd for a
postgres database.  Our configuration is to use a central server to host
the data, and various machines send the data to that server.

I've added the following to /etc/collectd.conf on a working machine and
restarted collectd, but the postgres data is not appearing in the UDP
packets.  I have confirmed this with tcpdump.

LoadPlugin "postgresql"

...

<Plugin "postgresql">
  <Query eventcount>
    Statement "SELECT COUNT(*) AS count FROM events;"
    <Result>
      Type counter
      InstancePrefix "eventcount"
      ValuesFrom "count"
    </Result>
  </Query>

  <Database dwh>
    Host "192.168.X.YY"
    User "dbuser"
    Password (correct password)
    Query eventcount
  </Database>
</Plugin>


The connection information for the database works, confirmed with psql.

There are no error messages in the logfile, we're using the logfile
plugin at loglevel debug.

Any debugging tips appreciated.

James Armstrong