Re: SNMP Collection with PostgreSQL Stored Proc, what lang?

On 02/01/2014 12:59 PM, bobspero wrote:
> I have a postgresql dB where I want to SNMP some information from a few
> servers and store them in my database. Is this something that can be done
> with a stored procedure or do I have to build an external utility type of
> app? If it is doable is this something the postgeres language or do I have
> to do something like python or java?

In Postgres procedural languages are found in two flavors trusted and
untrusted. Untrusted can reach out from the database into the file
system and do things. This would be what you want if you want to work
from a function in the database. plpythonu is untrusted and there is an
untrusted version of plperl, there may be others. plpgsql is trusted
and would not work for what you have in mind. The other option, is as
you say build a middleware application that feeds into the database.

>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/SNMP-Collection-with-PostgreSQL-Stored-Proc-what-lang-tp5790117.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com