Postgres Pro
Downloads
Home   >   mailing lists

Re: Updating a pre-10 partitioned table to use PG 10 partitioning - Mailing list pgsql-general

From Michael Paquier
Subject Re: Updating a pre-10 partitioned table to use PG 10 partitioning
Date
Msg-id 20180112014008.GC2222@paquier.xyz
Whole thread Raw
In response to Updating a pre-10 partitioned table to use PG 10 partitioning  (Alban Hertroys <haramrae@gmail.com>)
Responses Re: Updating a pre-10 partitioned table to use PG 10 partitioning  (Keith <keith@keithf4.com>)
List pgsql-general
Tree view 
On Thu, Jan 11, 2018 at 04:40:30PM +0100, Alban Hertroys wrote:
> What is a good approach here?

By having a some point an origin and target table in the same cluster,
you would just need to define things properly. I have not checked, but
perhaps this is the kind of use cases where pg_partman
(https://github.com/keithf4/pg_partman/) can become handy? Perhaps
Keith, who maintains the tool, has some insight on the matter.
--
Michael
Attachment

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Missing WAL file after running pg_rewind
Next
From: armand pirvu
Date:
Subject: Re: characters converted to ??? in postgres