On 1/22/24 19:11, Siraj G wrote:
Hello!
I would like to know how we can backup certain months old data from
PgSQL and then delete it. The intent is to backup everything that is
older than 2 quarters to a blob storage and delete it, to improve
performance and reduce billing.
1) Postgres
On Mon, Jan 22, 2024 at 10:12 PM Siraj G wrote:
> Hello!
>
> I would like to know how we can backup certain months old data from PgSQL
>
Use the COPY command.
> and then delete it.
>
That would depend on how many records, how big the records are, and if
there's index su
Hello!
I would like to know how we can backup certain months old data from PgSQL
and then delete it. The intent is to backup everything that is older than 2
quarters to a blob storage and delete it, to improve performance and reduce
billing.
Regards
Siraj
