Re: [collectd] Not seeing postgres data from collectd.

2010-03-12 Thread James Armstrong
Sebastian Harl wrote: Hi, On Wed, Mar 10, 2010 at 10:47:39AM -0800, James Armstrong wrote: Sebastian Harl wrote: On your local machine, are there any files in /var/lib/collectd/rrd/ hostname/postgresql-dwh/? Are there any other files in /var/lib/collectd/rrd/ (on the local machine)?

Re: [collectd] Not seeing postgres data from collectd.

2010-03-11 Thread Sebastian Harl
Hi, On Wed, Mar 10, 2010 at 10:47:39AM -0800, James Armstrong wrote: Sebastian Harl wrote: On your local machine, are there any files in /var/lib/collectd/rrd/ hostname/postgresql-dwh/? Are there any other files in /var/lib/collectd/rrd/ (on the local machine)? Here is the problem!

Re: [collectd] Not seeing postgres data from collectd.

2010-03-09 Thread James Armstrong
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. Sebastian Harl wrote: Hi, On Mon, Mar 08, 2010 at 01:04:19PM -0800, James Armstrong wrote: We're trying to add a

Re: [collectd] Not seeing postgres data from collectd.

2010-03-09 Thread Sebastian Harl
Hi James, On Tue, Mar 09, 2010 at 03:36:31PM -0800, James Armstrong wrote: Sebastian Harl wrote: On Tue, Mar 09, 2010 at 01:51:24PM -0800, James Armstrong wrote: Sebastian Harl wrote: One possibility, this query takes a while to return, over 30 seconds. Could it be timing out, and if so,

Re: [collectd] Not seeing postgres data from collectd.

2010-03-08 Thread Sebastian Harl
Hi, On Mon, Mar 08, 2010 at 01:04:19PM -0800, James Armstrong wrote: 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