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