BandwidthD with PostgreSQL, especially for SG-3100

tsimmons

Well, hell. I purchased an SG-3100 and was looking to get BandwidthD running with PostgreSQL support and discovered that NOPE, it isn't built with the supported database feature. This is the message in the logs (even though the config indicates it is possible):

Postgresql logging selected but postgresql support is not compiled into binary.

After burning several days trying to get this to work (including compiling my own BandwidthD with a FreeBSD VM) I failed to notice that the SG-3100 is ARM/ which means my VM (using Parallels on a Macbook Pro) won't build a compatible binary. From the thread https://forum.netgate.com/topic/116152/bandwidthd-is-coming-back-soon/ posted about a year ago by @jimp) I see others asking for Postgres support. Is there any chance that this might happen now that it is nearly a year later?

Thanks &
Cheers.

justme2

Can confirm that this is still an open issue for most recent, as received a slew of these in the logs:

Postgresql logging selected but postgresql support is not compiled into binary. Please check the documentation in README, distributed with this software.

Without support to write the data to PostgreSQL, bandwidthd is consuming vasts amounts of CPU to generate output that would be better handled elsewhere and "as needed".