Re: Moving child tables to partitions? - Mailing list pgsql-admin

From Keith Fiske
Subject Re: Moving child tables to partitions?
Date
Msg-id CAODZiv60=GLEH+z+zvz7HNrAKLaVkex0KV1yqT74VKe=wvoMiQ@mail.gmail.com
Whole thread Raw
In response to Moving child tables to partitions?  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin


On Tue, Jan 7, 2020 at 1:54 PM Wells Oliver <wells.oliver@gmail.com> wrote:
Is this a possible thing? I'd like to consolidate some older child/parent style relationships into the newer partition style.

--

Yes, this is certainly possible. Whether it's easy or complex really depends on your original partitioning setup, though. I've got an initial draft up for doing this sort of migration when using pg_partman. While some of the steps use things specific to pg_partman, the overall process should be the same for any migration. I'll be including the finalized doc in my next release.

 
--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com

pgsql-admin by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: Alter command getting stuck on a table
Next
From: Shrikant Bhende
Date:
Subject: Re: Alter command getting stuck on a table