From: | Hellmuth Vargas <hivs77(at)gmail(dot)com> |
---|---|
To: | Brajendra Pratap Singh <singh(dot)bpratap766(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Partitioned Table conversion to Non-Partition table in postgresql open source |
Date: | 2020-12-28 21:27:49 |
Message-ID: | CAN3Qy4op1KgUVdaHhkg0bkX61zVadgg93Uo4Y710vMnH61eRYg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
I had already read about some procedures to do that
https://www.enterprisedb.com/blog/postgres-partition-upgrade-your-partitioning-inheritance-declarative
https://www.2ndquadrant.com/en/blog/how-to-migrate-from-inheritance-based-partitioning-to-declarative-partitioning-in-postgresql/
El lun, 28 de dic. de 2020 a la(s) 04:38, Brajendra Pratap Singh (
singh(dot)bpratap766(at)gmail(dot)com) escribió:
> Hi,
>
> Currently we are running on open-postgresql 9.6 version with some
> partitioned Table which we need to convert from Inheritance partitioning to
> declarative partitioning during migration to 12.3 open-postgresql version.
>
> Is there any safest and faster way to fulfill this requirement, Please
> suggest?
>
> Thanks and regards,
> Singh
>
>
>
--
Cordialmente,
Ing. Hellmuth I. Vargas S.
Esp. Telemática y Negocios por Internet
Oracle Database 10g Administrator Certified Associate
EnterpriseDB Certified PostgreSQL 9.3 Associate
From | Date | Subject | |
---|---|---|---|
Next Message | Muthukumar.GK | 2020-12-29 06:34:57 | Re: Dynamic procedure execution |
Previous Message | Michael Lewis | 2020-12-28 14:14:50 | Re: Is there a good discussion of optimizations? |