check postgresql with Nagios ,!!!!
 

hi everyone ,
i have nagios installed on my debain and Postgresql on my client ( i already configured NRPE and Nagios Everything work Perfectly ) i want to check my postgresql from My server ( nagios ) so can someone help me please on how to Make it happen !!
thank you in advance
ps:I truly need your help can you give/show me the method how to configure it ,i saw that there is a Plugin wish is "check_postgres.pl" i went through a few tutos but i didn't get the idea so that is why i am asking for your help

you really *don't* need our help, you need to just type "nagios postgresql" into goolge and read the first result as a starting point.

This goes along with your other two Nagios related threads:
http://www.linuxquestions.org/questi...os-4175451299/
http://www.linuxquestions.org/questi...on-4175446199/

Again, as has been said before, you need to do some basic research first. Putting "monitor postgresql with nagios" into Google pulls up 541,000 hits. The first few are FROM THE NAGIOS WEBSITE...AGAIN. The same place you were directed for your Tomcat question and the NRPE question...seems like you'd have checked there first, since you were directed there twice before. And, again, you say you've gone "through a few tutos", but don't bother saying WHICH tutorials, or what you're confused about.

Which would indicate that you want someone to spoon-feed you an answer again. Thanks, but no; the first hit in Google pulls up SEVERAL PostgreSQL plugins for Nagios. Find them on your own.

thank you for both of you for your answers ,But " TB0ne" Just To let you know i am not stupide , it is not like i am lazy or idiote i know that if google it hundreds of results would pop up and that is what i do ,and for TOMCAT and NRPE Questions i Found sulotions on MY OWN so before posting this thread i looked it up, it's just because google pulls up a lot of hits that i am confused a litte that is why i ask you guys to clear up my confusion ,SO SORRY because i have to show which tuto i read so you can help I AM WRONG ,IT'S MY FAULT :( , okey here are two of them :

1) http://wiki.tyk.nu/index.php?title=C...stgreSQL_check
and= 2) http://vibhorkumar.wordpress.com/201...ppas-on-linux/

so i am confused here in tuto 1 and 2 they defined the command differently in tuto 2 : for the command line it is defined like this
== command_line $USER1$/check_postgres.pl --host $HOSTADDRESS$ --dbuser=enterprisedb --dbpass=edb -db edb -p 5444 --action bloat
while in tuto 1 : check_command check_nrpe2!check_pgsql
i know they added arguments but what are those arg for in tuto 2 :
which one of the 2 tutos should i follow ?? thank you in advance

I doubt that. If you did, then why did you post those threads, if you already had a solution?? Seems a bit pointless to ask a question when you already know the answer.
Sorry, but that's just not true. You ask questions that have VERY easily found answers. Asking for someone to look it up for you is a bit much...and if you found lots of hits, then PICK ONE AND TRY IT. If it doesn't work, try something else...that's how you learn. Like when you were directed to the tomcat plugin, you said "yes i saw that already , so what do i have to do to make it work then, can you show me"...when the installation instructions were with the plugins. So, either you didn't look for them plugins, or didn't read the instructions.
Great...and why should you post them? Because saying "I followed a tutorial", tells us NOTHING about what you may have done, or what results you may have gotten from it. We can't guess, and shouldn't have to. Provide details, and ask a clear question.
The two tutorials are very clearly marked. One is for using NRPE, the other is for a dedicated perl script. Obviously the arguments for both are going to be different. Again, if you read the README file that comes with the perl script, it will give you some hints. If you open the perl file, it explains EVERYTHING, almost line by line.

Again: PICK ONE...either will obviously work, they just do the same thing differently. Try them both. Decide yourself.

Are you saying that i am lying to you now by saying ; I post a thread because i want to make sure of what i am doing , if it is pointless from your point of view so it is not from mine , as i said before am not an idiote ,i read ,i search , and i TRY everything to see if is going to work or not , And For Tomcat and nrpe i didn't say i ALREADY had the solution If it was the case why would i ask you then !!, it's just waisting of time , i meant I found the solution ON MY OWN eventually while SEARCHING and TRYING everything ,How did it work for me then if i did not search and Try like you said !!,and sorry to say this but you are a bit rude and rough when you answer , can you just answer a bit more nicely and show some respect i know that you are trying to advise me but that is not the right way, you are talking to me like i am some stupide , ignorant girl.

and here : you actually didn't say anything , i know already that they are different and i know that is for perl , that is why am asking for help to make it clear for me and you didn't make it clear AT ALL , i already told you i am new to linux and Nagios so i need someone to explain to me not to tell me what i already know because for a beginner it is a bit confusing and it SEEMS complicated.(maybe it's not)
and again if whoever posts a thread and you tell him to decide himself why would a FORUM exist then !! why would people put their threads ?? i think it's created to help them to clear up the confusion not to tell them go READ what they find , they come here because they already read it but didn't get it so they ask for help ,again ; to Make it clear ; and by chance they may find someone who already faced the same problem .that is why i told you " which one to follow out of the two tutos " if by any chance you guys already know .

so thank you for your consideration and quick reply and sorry but i'm so straightfroward and i'm trying both tutos but i didn't get what those arg are for that is why am asking , so i am going to figure out my self like you said , it's better i think :)

And if you already tried it, you would then already know if it worked or not.
You said, in this very thread, that you found solutions on your own, before posting your questions.
How it worked was that people here looked things up and gave them to you. No where, in any of your threads, do you actually show that you've put any effort into things on your own. If you posted "I've looked at these sites (xxx, yyy, zzz), and they're all a bit different, and I'm getting these error(s) when trying something, can someone help?", that would show some effort. Posting "I need to monitor tomcat with Nagios, help!", or in this thread, all you posted is "want to check my postgresql from My server ( nagios ) so can someone help me please on how to Make it happen !!". Where does it show you putting any effort into looking this up? Trying anything?

Don't like it? Then take the hints myself and others have given you, and show some effort of your own. Want someone to be nice to you? Then PAY for support...they'll be happy to look things up for you with a smile.
Again, if you know they're different, then you know why the commands are different. Again, since it wasn't clear enough the first time:

• The check_postgres.pl file needs command-line arguments so it knows what postgres server to check, how to log in, etc.
• The NRPE plugin doesn't, since it's using the NRPE framework.

That's it. Those are the differences...can't be more plain, unless you want to pull the source code apart line by line, to figure out ALL the differences.
Forums exist for PROBLEMS. Things like "I ran this program, and got this error...can anyone help me?". What you're asking for is an OPINION ON WHAT'S BEST FOR YOU. Amazingly, the only person who can decide that IS YOU. You have two options...you are not having PROBLEMS, just asking which of the two things (which BOTH DO THE SAME THING), you should use.

Again: they're both free, they're both well documented. Try them both...decide FOR YOURSELF which YOU want. If you have actual PROBLEMS or ERRORS, post them.