Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Joe Tailleur <joe.tailleur@xxxxxxxxx>
Subject: Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL
From: Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx>
Date: Fri, 30 May 2025 07:56:31 -0600
Cc: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAPZdUVrsOCDPYKy3HbO-g+zMo5a41r03f_O4KE=gN=KLePKN9A@mail.gmail.com>
References: <CAL5GnivMgBgRdY9YTLmAQKQa=TQVTRwghiGovK6Q6XxScdGOzg@mail.gmail.com> <CAPZdUVoT6VMQY4UeUhO_z4t8J6Re9qpUX3fuo+xH-Qc4xzbbkw@mail.gmail.com> <9B8D6FBB-9ECE-4A19-84D2-FF258412D552@elevated-dev.com> <CAPZdUVrsOCDPYKy3HbO-g+zMo5a41r03f_O4KE=gN=KLePKN9A@mail.gmail.com>

> On May 30, 2025, at 7:50 AM, Joe Tailleur <joe.tailleur@xxxxxxxxx> wrote:
> 
> It allows me to easily backup the schema (regardless of the number of tables).  I can move several tables into that schema, and back up the schema.  

Ah--my mind was stuck on one-at-a-time thinking.

References:
- Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL
  - From: Motog Plus
- Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL
  - From: Joe Tailleur
- Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL
  - From: Scott Ribe
- Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL
  - From: Joe Tailleur

Prev by Date: Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL
Next by Date: Re: pg_dump verbose start and stop times?
Previous by thread: Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL
Next by thread: Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]