Hi,
Is there a way to prune analytics data from Analytics Data stored on PostgreSQL 14.13 Database server starting from 1st September 2023 till February 29, 2024 and archive it to a tape drive or network file storage? (Six months analytics data). This is to make sure we do not run into an out of disk/storage space situation. Once we carry out the prune operation, we only have 6 months of data in the PG Database server and the older data beyond six months will be on tape drive or network file storage.
I am running PostgreSQL 14.13 on RHEL 8.10 OS. Is there a way to Prune or Purge data stored on PostgreSQL 14.13 ?
For example I have Analytics data stored in PostgreSQL 14.13 server for last 1 year (1st September 2023 till date)
Is there a way to prune analytics data from Analytics Data stored on PostgreSQL 14.13 Database server starting from 1st September 2023 till February 29, 2024 and archive it to a tape drive or network file storage? (Six months analytics data). This is to make sure we do not run into an out of disk/storage space situation. Once we carry out the prune operation, we only have 6 months of data in the PG Database server and the older data beyond six months will be on tape drive or network file storage.
Please guide me. Thanks in advance.
Best Regards,
Kaushal
