Is it possible to auto-reconnect to the DB when the connection is lost? For reasons that pass understanding, sometimes, pmacct decides it lost the connection to the DB, at which point it just dies:
Jun 19 04:01:53 host nfacctd[24062]: INFO: connection lost to 'out-pgsql'; closing connection. Jun 19 04:01:53 host nfacctd[24062]: INFO: no more plugins active. Shutting down. At that time, our PostgreSQL server didn't log anything: 2013-06-17 16:51:46 UTC HINT: Consider increasing the configuration parameter "checkpoint_segments". 2013-06-17 16:51:48 UTC LOG: checkpoints are occurring too frequently (2 seconds apart) 2013-06-17 16:51:48 UTC HINT: Consider increasing the configuration parameter "checkpoint_segments". 2013-06-17 17:53:52 UTC WARNING: pgstat wait timeout 2013-06-17 23:58:02 UTC WARNING: pgstat wait timeout 2013-06-19 07:52:18 UTC LOG: checkpoints are occurring too frequently (25 seconds apart) 2013-06-19 07:52:18 UTC HINT: Consider increasing the configuration parameter "checkpoint_segments". (The 7:52 one is when I restarted it now. And, yeah, gonna fix the psql stuff, but so far it's been not a problem, as the load on the machine is literally 0 as long as we don't do stupid stuff like try to read the hundreds of GB of data) -- George-Cristian Bîrzan
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
