Re: Partitioning an existing table - pg10.6

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Partitioning an existing table - pg10.6
Date: 2019-07-03 08:37:31
Message-ID: 1562143051610-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I didn’t test it myself but maybe using logical réplication could help ...
See https://www.postgresql.org/docs/10/logical-replication.html

Operations
- create parttable
- Feed it using réplication
- when sync : stop app, stop réplication, rename tables
- maybe you can réplicate from parttable to nonpart as a rollback plan
- ...

To be tested carrefully
Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karl Martin Skoldebrand 2019-07-03 11:30:09 Too short field
Previous Message Achilleas Mantzios 2019-07-03 08:35:01 Re: Partitioning an existing table - pg10.6