Re: [GENERAL] Monitoring tools for Postgresql

2009-07-29 Thread mukeshp
I am running postgresql server on RHEL 5 system. Greg Smith-12 wrote: > > On Tue, 28 Jul 2009, mukeshp wrote: > >> Can anyone suggest me tools for monitoring postgresql server. ? > > An idea what operating system you're running the server on would help > here. > > -- > * Greg Smith gsm...@g

Re: [GENERAL] Monitoring tools for Postgresql

2009-07-28 Thread Christophe Pettus
On Jul 28, 2009, at 11:24 PM, mukeshp wrote: Can anyone suggest me tools for monitoring postgresql server. ? As it happens, there was a talk about that very topic on PG day: Check Please! What Your Postgres Databases Wishes You Would Monitor / Robert Treat / OmniTI http://media.postgresq

Re: [GENERAL] Monitoring tools for Postgresql

2009-07-28 Thread Greg Smith
On Tue, 28 Jul 2009, mukeshp wrote: Can anyone suggest me tools for monitoring postgresql server. ? An idea what operating system you're running the server on would help here. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list

[GENERAL] Monitoring tools for Postgresql

2009-07-28 Thread mukeshp
Hello Can anyone suggest me tools for monitoring postgresql server. ? -- View this message in context: http://www.nabble.com/Monitoring-tools-for-Postgresql-tp24713155p24713155.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list

Re: [GENERAL] monitoring tools

2004-12-23 Thread Dick Davies
* Lonni J Friedman <[EMAIL PROTECTED]> [1217 18:17]: > I dunno, can ruby by used in windows? I haven't touched a windows box > in about 10 years. Yup, see : http://rubyforge.org/projects/rubyinstaller/ -- 'Interesting. No, wait, the other thing - Tedious.' -- Bender Rasputin

Re: [GENERAL] monitoring tools

2004-12-23 Thread Lonni J Friedman
ll > though I liked pqa. Can it be run from windows? > > > -Original Message- > From: Lonni J Friedman [mailto:[EMAIL PROTECTED] > Sent: Thu 12/23/2004 10:39 AM > To: Jason Tesser > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] monitoring tools >

Re: [GENERAL] monitoring tools

2004-12-23 Thread Jason Tesser
gresql.org Subject: Re: [GENERAL] monitoring tools pqa does exactly what your original question requested. Sounds like what you really want is a GUI for pqa. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] monitoring tools

2004-12-23 Thread Lonni J Friedman
[mailto:[EMAIL PROTECTED] > > Sent: Thu 12/23/2004 8:11 AM > > To: Jason Tesser > > Cc: pgsql-general@postgresql.org > > Subject: Re: [GENERAL] monitoring tools > > > > Sure, in postgresql.conf uncomment log_min_duration_statement and set > > it to whatever value

Re: [GENERAL] monitoring tools

2004-12-23 Thread Scott Marlowe
ven a gui client or something? > > -Original Message- > From: Lonni J Friedman [mailto:[EMAIL PROTECTED] > Sent: Thu 12/23/2004 8:50 AM > To: Jason Tesser > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] monitoring tools > > Checkout pqa > > > O

Re: [GENERAL] monitoring tools

2004-12-23 Thread Jason Tesser
/23/2004 8:50 AM To: Jason Tesser Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] monitoring tools Checkout pqa On Thu, 23 Dec 2004 08:14:41 -0600, Jason Tesser <[EMAIL PROTECTED]> wrote: > But that will just st in a huge tet sticks all data in text filess. I need a > tool th

Re: [GENERAL] monitoring tools

2004-12-23 Thread Lonni J Friedman
@postgresql.org > Subject: Re: [GENERAL] monitoring tools > > Sure, in postgresql.conf uncomment log_min_duration_statement and set > it to whatever value you want to log. This, of course, assumes that > you're already logging for the DB. > > On Thu, 23 Dec 2004 07:27:22 -060

Re: [GENERAL] monitoring tools

2004-12-23 Thread Jason Tesser
:-) -Original Message- From: Lonni J Friedman [mailto:[EMAIL PROTECTED] Sent: Thu 12/23/2004 8:11 AM To: Jason Tesser Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] monitoring tools Sure, in postgresql.conf uncomment log_min_duration_statement and set it to whatever value you

Re: [GENERAL] monitoring tools

2004-12-23 Thread Lonni J Friedman
Sure, in postgresql.conf uncomment log_min_duration_statement and set it to whatever value you want to log. This, of course, assumes that you're already logging for the DB. On Thu, 23 Dec 2004 07:27:22 -0600, Jason Tesser <[EMAIL PROTECTED]> wrote: > I am looking for a tool in postgres to monito

[GENERAL] monitoring tools

2004-12-23 Thread Jason Tesser
I am looking for a tool in postgres to monitor present and past activity. Foe example in SQLServer there is a tool that reports on all queries run in the past say 2 weeks and tells you how long they took etc.. I know I can use explain in postgres but I want to be able to track my queries in a