pgosquery - 类似于非死book的OSQuery但基于Postgres
jopen
10年前
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)
非死book的OSQuery看起来真棒，但复杂地构建在SQLite数据库基础之上。Postgres的外部数据封装器似乎是一个更好的基础。