Had to get some metrics out of an old Cisco box that weren’t available through SNMP, and the only solution I could come up with was to periodically SSH some commands and regex the results.
That required way too much shell-foo and the SSH daemon would just randomly refuse/drop connections.
If only there was some kind of standard metric API that every other modern software supports out of the box…
I would just have Postgres running statically on some solid hardware. It’s easy to configure permissions and connections, too.
Not too hard to set up streaming replication for a hot standby if you wanna be sure (or offload some reads).
I use Postgres btw