From: Kevin Kempter <kevink@consistentstate.com>
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
Message-ID: <201006091010.44437.kevink@consistentstate.com> (raw)
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...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kevink@consistentstate.com
Subject: Re: insert OS command results into a table on a remote system ?
In-Reply-To: <201006091010.44437.kevink@consistentstate.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox