On several occasions, I noticed flowd not starting after a power failure. This seems to originate from database corruption, which can't be repaired by a 'repair Netflow data' in the GUI. If I reset the Netflow data and restart flowd, all is well.
Is there something I can do to make Netflow more resilient to power outages? Can switching to ZFS - if possible - help with this?
A UPS will solve the issue completely and should be used regardless.
A UPS can be inexpensive or expensive that's up to what you need or want. But it is always less expensive than replacing equipment.
I see your point, but keeping in mind that I use OPNsense for home/hobby purpose, I was hoping to be able to solve this in system configuration, not by adding new hardware ;)
I had the same problem and the only way i solved it was adding another ups.
My original one was a bit overloaded and marginal for what i was asking it to do.
I never had the data base so corrupted it couldn't be fixed though.
I agree adding more equipment does suck but i know no other way to keep a data base from being corrupted by a sudden shut down.
This is one of the times that adding something in the way of equipment or a UPS is the way to remedy the situation unfortunately.