insert OS command results into a table on a remote system ?

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: insert OS command results into a table on a remote system ?
Date: 2010-06-09 16:10:44
Message-ID: 201006091010.44437.kevink@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tim Landscheidt 2010-06-09 17:00:41 Re: insert OS command results into a table on a remote system ?
Previous Message Tom Lane 2010-06-09 15:56:42 Re: Fatal Error during PITR Recovery