Postgres Pro
Downloads
Home   >   mailing lists

Moving from PG 9-era table inheritance to PG 12 range partioning - Mailing list pgsql-admin

From Wells Oliver
Subject Moving from PG 9-era table inheritance to PG 12 range partioning
Date
Msg-id CAOC+FBWenMJVfwxRvDqWmsyk62zZVUUFWS_kh3xv-OROVu15Xg@mail.gmail.com
Whole thread Raw
Responses Re: Moving from PG 9-era table inheritance to PG 12 range partioning  (Keith <keith@keithf4.com>)
List pgsql-admin
Tree view
I was thinking of moving a set of partitioned tables using inheritance (done in PG 96.) to the new(ish) range partitioning available in 10/11/12...

My plan was to make another schema and create the new range-partitioned tables, then copy the data into them, then drop the older tables and re-set the schema for the new partitioned tables to the old schema, essentially meaning the new partitioned tables will take the place of the older tables when I am ready. Same exact structure, just different under the hood.

Any issues with this plan? Will changing the schema of the new partitioned table break anything?

--

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: In AIX server encoding utf8 is not supported
Next
From: Keith
Date:
Subject: Re: Moving from PG 9-era table inheritance to PG 12 range partioning