Re: Updating a pre-10 partitioned table to use PG 10 partitioning

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Alban Hertroys <haramrae(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Updating a pre-10 partitioned table to use PG 10 partitioning
Date: 2018-01-12 01:40:08
Message-ID: 20180112014008.GC2222@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message armand pirvu 2018-01-12 01:52:03 Re: characters converted to ??? in postgres
Previous Message Michael Paquier 2018-01-12 01:37:41 Re: Missing WAL file after running pg_rewind