| From: | Kaushal Shriyan <kaushalshriyan(at)gmail(dot)com> |
|---|---|
| To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Prune or Purge data stored on Postgres 14.13 |
| Date: | 2024-10-11 18:43:30 |
| Message-ID: | CAD7Ssm8X2Z89sgKyoeeG=yrxgRX722MqbgGfypp4a=9kp0wmcg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Wienhold | 2024-10-11 23:19:02 | Re: Prune or Purge data stored on Postgres 14.13 |
| Previous Message | Durgamahesh Manne | 2024-10-11 18:03:15 | Re: Inefficient use of index scan on 2nd column of composite index during concurrent activity |