public inbox for [email protected]  

help / color / mirror / Atom feed

From: Kaushal Shriyan <[email protected]>
To: Postgres General <[email protected]>
Subject: Prune or Purge data stored on Postgres 14.13
Date: Sat, 12 Oct 2024 00:13:30 +0530
Message-ID: <CAD7Ssm8X2Z89sgKyoeeG=yrxgRX722MqbgGfypp4a=9kp0wmcg@mail.gmail.com> (raw)

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

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Prune or Purge data stored on Postgres 14.13
  In-Reply-To: <CAD7Ssm8X2Z89sgKyoeeG=yrxgRX722MqbgGfypp4a=9kp0wmcg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox