Welcome Guest [Log In] [Register]
Add Reply
Missing data older than 3 days in Postgres
Topic Started: Apr 6 2018, 01:37 PM (4 Views)
JohnHale

Hi,

This query seems to work fine. The trouble I'm having is that the tables queried here all seem to only store about 3 days worth of data. Anything older is dropped from the tables.I have the reporting module set to keep history up to 30 days. Is this data being moved to another table, or am I just missing something? I'm no Postgres guru so maybe my query is just broken. Im not sure if it matters but I'm just performing these queries on the command line?

Please help.

I didn't find the right solution from the Internet.

References:-
https://forums.untangle.com/web-monitor/13296-missing-data-older-than-3-days-postgres.html
Medical advertising examples

Thanks
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · General Discussion · Next Topic »
Add Reply