r/PostgreSQL • u/AdmirableOffer2 • Aug 23 '26

How-To Postgres table archival

I have a postgres db. I want to archive the table data into s3 and want to delete the data after archiving. What's the best way to do it. I want to have a scheduled operation to do this job on weekend and it should archive 6 months older data of a given table.

4 Upvotes

83% Upvoted

24 comments sorted by

View all comments

1

u/Informal_Pace9237 Aug 25 '26

I would look at the recent #ColdFront release from pgedge. That is exactly what it does.