[collectd] Not seeing postgres data from collectd.

[Sebastian Harl]

Hi,

On Tue, Mar 09, 2010 at 01:51:24PM -0800, James Armstrong wrote:
> Many thanks for you assistance.  I come from a MySQL and Oracle
> background, and don't have much experience with postgres...  So this is
> a bit of a learning experience for me.

Sure, no problem :-)

> Sebastian Harl wrote:
> One possibility, this query takes a while to return, over 30 seconds.
> Could it be timing out, and if so, how can I change the timeout for this
> query without changing other intervals?

(Leaving out everything else for now, as this seems to be the most
likely cause for your issue. Will come back to the other information in
case we don't find any solution.)

I would not expect the query to time out (it runs fine from an
interactive client, which should basically be the same). However, it
will cause RRDtool to generate an empty graph. Do you use the rrdtool
plugin? Did you really make sure that *no* data at all arrives at the
server? Does collectd create any RRD files at all ($hostname/ 
postgresql-dwh/counter-eventcount.rrd)? Is there any data in that file
(run 'rrdtool fetch path/to/counter-eventcount.rrd MAX')? Did you try to
store the collected data on the client as well? Does that work fine?

Cheers,
Sebastian

-- 
Sebastian "tokkee" Harl +++ GnuPG-ID: 0x8501C7FC +++ http://tokkee.org/

Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety.         -- Benjamin Franklin

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
Url : http://mailman.verplant.org/pipermail/collectd/attachments/20100309/3ec7ac13/attachment.pgp