Postgres Pro
Downloads
Home   >   mailing lists

Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL
Date
Msg-id 9B8D6FBB-9ECE-4A19-84D2-FF258412D552@elevated-dev.com
Whole thread Raw
In response to Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL  (Motog Plus <mplus7535@gmail.com>)
Responses Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL
List pgsql-admin
Tree view 
> On May 30, 2025, at 7:39 AM, Joe Tailleur <joe.tailleur@gmail.com> wrote:
>
> Using table partitioning works well for me.  I detach and move the partition to an archive schema; which I can then
backupand restore into a separate database, and once that is complete, remove the table from the archive schema on the
livedatabase. 

What's the purpose of the archive schema?

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: pg_dump verbose start and stop times?
Next
From: Joe Tailleur
Date:
Subject: Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL