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--