[collectd] Not seeing postgres data from collectd.

[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!
> 
> The data is appearing in
> /var/lib/collectd/rrd/192.168.X.YY/postgresql-dwh/counter-eventcount.rrd
> 
> All the other data appears under the hostname directory.
> 
> So, it appears the postgresql plugin is using the Host from the
> <Database> stanza.  The database doesn't allow connections through the
> fully qualified domain name (that we use for the collectd collections.)
> Is there a way to tell the plugin that data from Host 192.168.X.YY
> should be associated with Hostname FQDN?

Yes, in case you're connecting through a UNIX socket or when connecting
to "localhost". I suppose, you're running PostgreSQL on the same
machine, right? In that case, simply leaving out the "Host" config
option will let the plugin connect to the UNIX socket.

So, you're getting values on the local machine now? Do you get the same
values on the central server as well?

HTH,
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/20100311/4dfd4fa2/attachment.pgp