Re: Moving child tables to partitions?

On Tue, Jan 7, 2020 at 1:54 PM Wells Oliver <wells(dot)oliver(at)gmail(dot)com> wrote:

> Is this a possible thing? I'd like to consolidate some older child/parent
> style relationships into the newer partition style.
>
> --
> Wells Oliver
> wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
>

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.

https://github.com/pgpartman/pg_partman/blob/migrate/doc/migrate_to_native.md

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