Postgres Pro
Downloads
Home   >   mailing lists

Prune or Purge data stored on Postgres 14.13 - Mailing list pgsql-general

From Kaushal Shriyan
Subject Prune or Purge data stored on Postgres 14.13
Date
Msg-id CAD7Ssm8X2Z89sgKyoeeG=yrxgRX722MqbgGfypp4a=9kp0wmcg@mail.gmail.com
Whole thread Raw
Responses Re: Prune or Purge data stored on Postgres 14.13
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Durgamahesh Manne
Date:
Subject: Re: Inefficient use of index scan on 2nd column of composite index during concurrent activity
Next
From: Erik Wienhold
Date:
Subject: Re: Prune or Purge data stored on Postgres 14.13