2016-11-30 14:21 GMT+13:00 John R Pierce <pie...@hogranch.com>: > On 11/29/2016 5:10 PM, Patrick B wrote: > > > Yep.. once a minute or so. And yes, I need to store a history with > timestamp. > > Any idea? :) > > > so create a table with a timestamptz, plus all the fields you want, have a > script (perl? python? whatever your favorite poison is with database > access) that once a minute executes those two queries (you'll need two > database connections since only the slave knows how far behind it is), and > inserts the data into your table. > > > -- > john r pierce, recycling bits in santa cruz > >
Can't I do it on the DB size? Using a trigger maybe? instead of using Cron? Patrick
