pgosquery - 類似于非死book的OSQuery但基于Postgres

pgosquery是一個類似于非死book的系統監控工具 OSQuery，但基于Postgres數據庫。

--------------------------------------------------------
-- get the name, pid and attached port of all processes

-- which are listening on localhost interfaces
SELECT DISTINCT 
    process.name, 
    listening.port, 
    process.pid
FROM processes AS process
JOIN listening_ports AS listening
ON process.pid = listening.pid
WHERE listening.address = '127.0.0.1';
name   | port | pid

----------+------+------
 postgres | 5432 | 6932
(1 row)</pre> 
非死book的OSQuery看起來真棒，但復雜地構建在SQLite數據庫基礎之上。Postgres的外部數據封裝器似乎是一個更好的基礎。 




項目主頁：http://www.baiduhome.net/lib/view/home/1414736548028