Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 11B216321AC for ; Wed, 9 Jun 2010 13:17:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 50272-01 for ; Wed, 9 Jun 2010 16:17:09 +0000 (UTC) X-Greylist: delayed 00:06:38.909676 by SQLgrey-1.7.6 Received: from cpoproxy3-pub.bluehost.com (cpoproxy3-pub.bluehost.com [67.222.54.6]) by mail.postgresql.org (Postfix) with SMTP id 4D70B632E4D for ; Wed, 9 Jun 2010 13:17:09 -0300 (ADT) Received: (qmail 4553 invoked by uid 0); 9 Jun 2010 16:10:28 -0000 Received: from unknown (HELO box498.bluehost.com) (66.147.242.98) by cpoproxy3.bluehost.com with SMTP; 9 Jun 2010 16:10:28 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=consistentstate.com; h=Received:From:Organization:To:Subject:Date:User-Agent:MIME-Version:Content-Type:Content-Transfer-Encoding:Content-Disposition:Message-Id:X-Identified-User; b=FsW9L1aC/b5gE2XaLV1TRnZup74t1RsZkB8ChOfRCmGzA4qUmLdClyjGsZ6ZjJa+a72nNhRTXUKdTlqki4rQxHsns6gpVoTE6bSe1DBDFOExFR2YyG+FgaHzSTgTiZ19; Received: from 173-164-51-9-colorado.hfc.comcastbusiness.net ([173.164.51.9] helo=[192.168.1.136]) by box498.bluehost.com with esmtpsa (SSLv3:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1OMNrH-00013p-U2 for pgsql-admin@postgresql.org; Wed, 09 Jun 2010 10:10:28 -0600 From: Kevin Kempter Organization: Consistent State To: pgsql-admin@postgresql.org Subject: insert OS command results into a table on a remote system ? Date: Wed, 9 Jun 2010 10:10:44 -0600 User-Agent: KMail/1.9.4 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201006091010.44437.kevink@consistentstate.com> X-Identified-User: {3049:box498.bluehost.com:consist3:consistentstate.com} {sentby:smtp auth 173.164.51.9 authed with kevink+consistentstate.com} X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/86 X-Sequence-Number: 34864 Hi All; I want to gather OS command based stats such as the results of commands like: 'df' 'iostat' 'free' etc and put the results into a temp table that I can then select from. I need to do this all from the db since I wont have OS/shell access, only 'psql -h' access. Is this possible? Can I somehow leverage the '\!' meta command in psql to pull results of OS commands into a table? Thanks in advance...