Thread: SNMP Collection with PostgreSQL Stored Proc, what lang?
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? -- 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.
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.klaver@gmail.com