Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Sun Jan 01, 2012 8:39 am 
Offline
Senior Member

Joined: Mon Dec 07, 2009 6:46 am
Posts: 331
Happy 2012 everyone!

Sober yet? Good. I need help setting up Munin plugins for PostgreSQL (on a CentOS 6 machine). I've symlinked a few of them into /etc/munin/plugins/ but I have no idea how to configure them via /etc/munin/plugins-conf.d/, I mean I don't know what I have to put in the config file.

What I want to do is monitor all the databases I have on the server, and then later I'll decide what to take out, what I really don't need monitored. So I've symlinked the plugins with _ALL suffix, but that's about it.

Google search returns several variants with different plugin names, different config entries etc... Currently I have in /etc/munin/plugin-conf.d/postgres which I added manually:


Code:
[postgres_*]
user postgres
env.PGUSER postgres


Which effectively results with the following in the munin-node.log:


Code:
2012/01/01-13:30:08 [12878] Service 'postgres_cache_ALL' exited with status 1/0.
2012/01/01-13:30:08 [12878] Service 'postgres_cache_ALL' exited with status 1/0.
2012/01/01-13:30:08 [12878] Service 'postgres_scans_ALL' exited with status 1/0.
2012/01/01-13:30:09 [12878] Service 'postgres_scans_ALL' exited with status 1/0.
2012/01/01-13:30:09 [12878] Service 'postgres_transactions_ALL' exited with status 1/0.
2012/01/01-13:30:09 [12878] Service 'postgres_transactions_ALL' exited with status 1/0.


Do I need to list each and every database and use env. to supply the database user (and password if connecting through localhost instead of unix socket)?


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group