Currently I am using the loraserver and lora_app_server and it is already working for more than a year without a problem. I am very happy with all the loraserver.io. Great Job Brocaar!
At the moment we are also increasing the amount of lora sensors a lot and I see that my Postgresql database ‘loraserver_ns’ keeps on growing and growing. At the moment the database is around 20GB.
I don’t know exactly what is stored in the database, but I guess al lthe messages that have been received? Is there a possibility to clean up the database in a way that I only store the data of the last 30 days?
Should I perform a manual SQL query maybe?
If I take a look at the database with PGAdmin (Postgresql tool for windows) I do not really see what is inside…
I am looking forward to your thoughts about this subject.
Thanx in advance.