Thread: i want to ask monitory peformance memory postgresql with automatically

i want to ask monitory peformance memory postgresql with automatically

From
Didik Prasetyo
Date:
Hi friend I Want to ask, is there any solutions or tools for monitoring memory performance in postgre automatically, for example, will send allert if Peformance memory has exceeded 90%

thank you for your help

Re: i want to ask monitory peformance memory postgresql with automatically

From
Craig Ringer
Date:
On 7/06/2011 3:47 PM, Didik Prasetyo wrote:
> Hi friend I Want to ask, is there any solutions or tools for monitoring
> memory performance in postgre automatically, for example, will send
> allert if Peformance memory has exceeded 90%

Use standard system monitoring tools like Nagios. There is a PostgreSQL
agent for Nagios that will help do some postgresql-specific monitoring,
but most of the monitoring you will want to do is system level and is
already supported by Nagios and similar tools.

--
Craig Ringer

Tech-related writing at http://soapyfrogs.blogspot.com/

Re: i want to ask monitory peformance memory postgresql with automatically

From
Marcos Ortiz
Date:
you can use Hyperic HQ too from SpringSource (a division of Vmware), but
the most usfel tools are the command tools (iostat, vmstat, top, free, lsof)
Regards

El 6/7/2011 5:58 AM, Craig Ringer escribió:
> On 7/06/2011 3:47 PM, Didik Prasetyo wrote:
>> Hi friend I Want to ask, is there any solutions or tools for monitoring
>> memory performance in postgre automatically, for example, will send
>> allert if Peformance memory has exceeded 90%
>
> Use standard system monitoring tools like Nagios. There is a
> PostgreSQL agent for Nagios that will help do some postgresql-specific
> monitoring, but most of the monitoring you will want to do is system
> level and is already supported by Nagios and similar tools.
>

--
Marcos Luís Ortíz Valmaseda
  Software Engineer (UCI)
  http://marcosluis2186.posterous.com
  http://twitter.com/marcosluis2186