Postgres Pro
Downloads
Home   >   mailing lists

Re: What monitoring tools to watch Pgsql 8.4? - Mailing list pgsql-admin

From Mathis, Jason
Subject Re: What monitoring tools to watch Pgsql 8.4?
Date
Msg-id CABAbqyexTfFw5j0HSMO4yxJhpeoVTzT2STp0RN49GP=Jcentog@mail.gmail.com
Whole thread Raw
In response to What monitoring tools to watch Pgsql 8.4?  (Chuck Roberts <croberts@gilsongraphics.com>)
List pgsql-admin
Tree view
There is a CLI section on this page:


the pganalyze-collector looks interesting. For graphs maybe you could use graphite? 

If you dont have shell access its a much more limited and I am not sure what is or is not going to work with 8.4. 

Hope that helps. Good luck!



On Tue, Jan 27, 2015 at 8:12 AM, Chuck Roberts <croberts@gilsongraphics.com> wrote:

Hi,

We have a closed box from a vendor with PGSql 8.4, and an unknown version of linux. I have read access to the db only. I have Windows 7 on my PC and I'd like to graph the database load from my PC. I do not have shell access to the OS on this box.


What tools are available to me to graph loads, number of queries, and such on this database engine?

 

I do have the psql command line client too.

 

Thank you.

 

p.s. No we cannot upgrade this pgsql, it's a closed system to us. Yes I know there will be no more updates to us, that's fine for now.

 


pgsql-admin by date:

Previous
From: Chuck Roberts
Date:
Subject: What monitoring tools to watch Pgsql 8.4?
Next
From: David Susa
Date:
Subject: Postgresql partitioning limit - possible bottlenecks