We have tried the below use case as part of Postgresql recovery.
Case: Recovery of Postgresql from backup dump when the previous analytics data was lost from postgres.
As per the backup & restore documentation, script takes the backup of dump and token directory:
We are able to recover the Postgresql from dump if any data got lost. But we are able to retrieve the postgres analytics in edge-Ui even if we don’t recover as well.
@SURESHT, How many Analytics nodes you have installed ? Analytics data might be available in server cache.
After 5min, did you see new traffic being updated ?
@Latheef, We have 2 analytics nodes in our test environment. After purging all the data from Postgres, I could see new traffic is being updated. Now my postgresql has recent analytics only.
As per latest update we received, When we purge the analytics, the detailed data only got deleted. But the views created on detailed data will not be deleted. Hence we would need to know how to purge view data as well.
@SURESHT, Hope this article helps .
https://community.apigee.com/questions/24894/how-to-purge-old-analytics-data-in-opdk.html