tableau / Logshark

A Tableau log file analysis utility
MIT License
112 stars 50 forks source link

Delete Old data from Logshark output written into local postgres #160

Open KarthikINV opened 1 year ago

KarthikINV commented 1 year ago

Hi Team,

We are using Logshark and writing/appending output to Postgres, but day by day data is increasing up, is there any easy way we can delete the data older than 1 month/2months data from postgres.

I'm trying to understand schema structure and thinking of building sql queries but don't want into getting trouble of deleting latest data as well.

Could you please help in providing delete sql queries to delete data older logshark data image