How to delete/purge rows from Central (PostgreSQL) after certain time in order to manage storage and data retention policy.
Basically we need to manage storage limits and data retention policy we must have to purge/delete rows in certain time of period (ex. 6 months). we are running ODK central (v1.2.0) with PostgreSQL database on Prem Linux server.
Need help on:
- How to delete submissions?
- How to connect inbuilt PostgreSQL to Database Client (ex. pgAdmin)?
Can some one guide me the the recommended approach to achieve this requirement?
Server : ODK Central (v1.2.0)
Database: PostgreSQL
Client: ODK Collect