MIME-Version: 1.0
From: Kaushal Shriyan <kaushalshriyan@gmail.com>
Date: Sat, 12 Oct 2024 00:13:30 +0530
Message-ID: <CAD7Ssm8X2Z89sgKyoeeG=yrxgRX722MqbgGfypp4a=9kp0wmcg@mail.gmail.com>
Subject: Prune or Purge data stored on Postgres 14.13
To: Postgres General <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b5a560062437dda3"
Archived-At: <https://www.postgresql.org/message-id/CAD7Ssm8X2Z89sgKyoeeG%3DyrxgRX722MqbgGfypp4a%3D9kp0wmcg%40mail.gmail.com>
Precedence: bulk

--000000000000b5a560062437dda3
Content-Type: text/plain; charset="UTF-8"

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

--000000000000b5a560062437dda3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>I am running=C2=A0PostgreSQL 14.13 =
on RHEL 8.10 OS. Is there a way to=C2=A0Prune or Purge data stored on Postg=
reSQL 14.13 ?</div><div><br></div><div>For example I have Analytics data st=
ored in PostgreSQL 14.13 server for last 1 year (1st September 2023 till da=
te)</div><div><br>Is there a way to prune analytics data from Analytics Dat=
a stored on PostgreSQL 14.13 Database server starting from 1st September 20=
23 till February 29, 2024 and archive it to a tape drive or network file st=
orage? (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 operat=
ion, 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.=C2=A0=
</div><div><br></div><div><div>Please guide me. Thanks in=C2=A0advance.=C2=
=A0</div><div><br></div><div>Best Regards,<br></div><div><br></div><div>Kau=
shal</div></div></div>

--000000000000b5a560062437dda3--