From croberts@gilsongraphics.com Tue Jan 27 14:25:27 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YG755-0000dF-Rk for pgsql-admin@arkaria.postgresql.org; Tue, 27 Jan 2015 14:25:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YG755-0006qc-C2 for pgsql-admin@arkaria.postgresql.org; Tue, 27 Jan 2015 14:25:27 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YG754-0006qV-5Q for pgsql-admin@postgresql.org; Tue, 27 Jan 2015 14:25:26 +0000 Received: from mail-we0-f178.google.com ([74.125.82.178]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YG74z-0002ls-Ob for pgsql-admin@postgresql.org; Tue, 27 Jan 2015 14:25:24 +0000 Received: by mail-we0-f178.google.com with SMTP id k48so15182695wev.9 for ; Tue, 27 Jan 2015 06:25:20 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:mime-version:thread-index:date:message-id :subject:to:content-type; bh=6A7jjcJas41w6OBDPnpRFOIYbW+iW6WyGZb3XDQodQ4=; b=YsT313ztZckLjf7rraJNA1X/dZnrwQ9XydHCZVwikv7Pwun50789SohD0RRQE+dwNO MvsJUQYr3cYxg2bkFsNcONZakWeeQ1IMFGxXckB7OsrsMQSWvx70HOlRil1fx5Vpffum OCA6eG1PPIQdpb1zG3Jwtnilpr0wBvnnGf8mQD0LMkDxFd1I9QTS6CzG2nFBXAh2DOCx jcDugUYNJ/pi4BYLbZdL3r9CsQ6JNYmAcNerkXYjKuxlRRmfEi9xABofw+fW2n+GsP7i BxDR/GmhsEckejKVb0adrPeeXgWHvt/5L7Be2VQjlqE4R4vXehJtNKhPFZPEM1OpGsk2 6j9w== X-Gm-Message-State: ALoCoQmClHu9GUqV1SVG0tJXq/4exgnq6X6gbJWRefuZX6WHkqf8o0Ne+7inrcS1OUMid3oIFOBi X-Received: by 10.194.203.104 with SMTP id kp8mr327633wjc.103.1422368720161; Tue, 27 Jan 2015 06:25:20 -0800 (PST) From: Chuck Roberts MIME-Version: 1.0 X-Mailer: Microsoft Outlook 14.0 Thread-Index: AdA6OuYivka8iPCBQPiOpZ6yjPghkg== Date: Tue, 27 Jan 2015 09:12:29 -0500 Message-ID: <753bf59df263785158709069920dbc8b@mail.gmail.com> Subject: What monitoring tools to watch Pgsql 8.4? To: pgsql-admin Content-Type: multipart/alternative; boundary=047d7bae493e4e27c2050da3065f X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --047d7bae493e4e27c2050da3065f Content-Type: text/plain; charset=UTF-8 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. --047d7bae493e4e27c2050da3065f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

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 acc= ess to the OS on this box.

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

=C2=A0

I do ha= ve the psql command line client too.

=C2=A0

<= p class=3D"MsoNormal">Thank you.

=C2=A0

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

=C2=A0

--047d7bae493e4e27c2050da3065f-- From jmathis@enova.com Tue Jan 27 16:40:07 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YG9BP-0006pz-Lk for pgsql-admin@arkaria.postgresql.org; Tue, 27 Jan 2015 16:40:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YG9BP-0005Xm-4n for pgsql-admin@arkaria.postgresql.org; Tue, 27 Jan 2015 16:40:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YG9BN-0005X4-Qh for pgsql-admin@postgresql.org; Tue, 27 Jan 2015 16:40:05 +0000 Received: from exprod5og105.obsmtp.com ([64.18.0.180]) by magus.postgresql.org with smtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YG9BI-0006Of-D2 for pgsql-admin@postgresql.org; Tue, 27 Jan 2015 16:40:04 +0000 Received: from mail-la0-f52.google.com ([209.85.215.52]) (using TLSv1) by exprod5ob105.postini.com ([64.18.4.12]) with SMTP ID DSNKVMe/WzLyPxX6/y74M/YqBKLplnzX9aP5@postini.com; Tue, 27 Jan 2015 08:40:00 PST Received: by mail-la0-f52.google.com with SMTP id ge10so14308463lab.11 for ; Tue, 27 Jan 2015 08:39:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enova.com; s=google; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=EfyA4B2ryTEwHk9P3nt5lmvbFyIpNjifjj7+qb/t1pA=; b=Nsv3F8ln2rUXBoHuy72+5EOJU9lyENt0FNutpBp+65U8/jzwWN7OGhA9IIYWqGj/Fr Z0hLiuJ/VR/jPJvK2x1kAXNdCUy7x+QqJjG3PL5yBgW0UOoxvKGdfoRo37tyi5lZAbNd wxwhylHVieS8mTGD9aRNFDB/eW4LtVaqv2RCs= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=EfyA4B2ryTEwHk9P3nt5lmvbFyIpNjifjj7+qb/t1pA=; b=l5J69YHeM+T8LiGIQL733uuOiwoEnv3EcZ2xcyZJElzLIDWCugKgKeSTc8ab8DvK4Q yWEtyz5CZHUtG7UNo+XE9apN/+NHKItL/oyF7Iioc0dEojAwA+NqPpydGjwH9SjNwRLr sowgqKLuNxmNlQZe2jORXrzsJ1e0m3sjuOIefgOilVRAAIY6RRPlPGQDsKGMvbUsZEHe GQ2uvSTdvFN87SDkQxeBPaNrDHHOjz0TA0Ys99TvLL3abq+o6195896ZFcZT15T6Dy37 OQQ6NQiHaaY561CTQvt1KdbQ9ryKVj31YMuFdTovgkU7UMVP6QnZ5BoMCDe0DSCtqM0y i1Ig== X-Gm-Message-State: ALoCoQk11hSZ+eIm5MHN+7GgkwgIooL4tsV4UzQmKS/52FP8mr9oGFa7443AngtFsmt45+ZYA7Gm10Q3cZhWjudMpfwwVj8HE6L6AjL0b2UcnJ1Uhm0bUYUF93tiXCSobYOGeY9e3ViWBI2FbW14+X1wYP776g9bvA== X-Received: by 10.112.167.228 with SMTP id zr4mr2939594lbb.20.1422376794635; Tue, 27 Jan 2015 08:39:54 -0800 (PST) MIME-Version: 1.0 X-Received: by 10.112.167.228 with SMTP id zr4mr2939573lbb.20.1422376794456; Tue, 27 Jan 2015 08:39:54 -0800 (PST) Received: by 10.112.12.98 with HTTP; Tue, 27 Jan 2015 08:39:54 -0800 (PST) In-Reply-To: <753bf59df263785158709069920dbc8b@mail.gmail.com> References: <753bf59df263785158709069920dbc8b@mail.gmail.com> Date: Tue, 27 Jan 2015 10:39:54 -0600 Message-ID: Subject: Re: What monitoring tools to watch Pgsql 8.4? From: "Mathis, Jason" To: Chuck Roberts Cc: pgsql-admin Content-Type: multipart/alternative; boundary=001a11c2432a921b72050da4e79e X-Pg-Spam-Score: -4.3 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --001a11c2432a921b72050da4e79e Content-Type: text/plain; charset=UTF-8 There is a CLI section on this page: https://wiki.postgresql.org/wiki/Monitoring 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 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. > > > --001a11c2432a921b72050da4e79e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

There is a CLI section on this page:

https://wiki.postgres= ql.org/wiki/Monitoring

the pganalyze-colle= ctor looks interesting. For graphs maybe you could use graphite?=C2=A0

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.=C2=A0

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 Wind= ows 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 suc= h on this database engine?
=C2=A0
I do have the psql command line client too.
=C2=A0
Thank you.
=C2=A0
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.
=C2=A0

--001a11c2432a921b72050da4e79e--