[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: Partitioned Table conversion to Non-Partition table in postgresql open source
From: Hellmuth Vargas <hivs77 () gmail ! com>
Date: 2020-12-28 21:27:49
Message-ID: CAN3Qy4op1KgUVdaHhkg0bkX61zVadgg93Uo4Y710vMnH61eRYg () mail ! gmail ! com
[Download RAW message or body]
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.bpratap766@gmail.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
[Attachment #3 (text/html)]
<div dir="ltr"><div>Hi<br></div><div><br></div><div>I had already read about some \
procedures to do that</div><div><br></div><div><br></div><div><a \
href="https://www.enterprisedb.com/blog/postgres-partition-upgrade-your-partitioning-i \
nheritance-declarative">https://www.enterprisedb.com/blog/postgres-partition-upgrade-your-partitioning-inheritance-declarative</a></div><div><a \
href="https://www.2ndquadrant.com/en/blog/how-to-migrate-from-inheritance-based-partit \
ioning-to-declarative-partitioning-in-postgresql/">https://www.2ndquadrant.com/en/blog \
/how-to-migrate-from-inheritance-based-partitioning-to-declarative-partitioning-in-postgresql/</a></div><div><br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">El lun, 28 de dic. de 2020 a \
la(s) 04:38, Brajendra Pratap Singh (<a \
href="mailto:singh.bpratap766@gmail.com">singh.bpratap766@gmail.com</a>) \
escribió:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div \
dir="auto">Hi,<div dir="auto"><br></div><div dir="auto">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.</div><div dir="auto"><br></div><div dir="auto">Is there any \
safest and faster way to fulfill this requirement, Please suggest?</div><div \
dir="auto"><br></div><div dir="auto">Thanks and regards,</div><div \
dir="auto">Singh</div><div dir="auto"><br><br></div></div> </blockquote></div><br \
clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div \
dir="ltr">Cordialmente, <br><br>Ing. Hellmuth I. Vargas S. <br>Esp. Telemática y \
Negocios por Internet <div>Oracle Database 10g Administrator Certified \
Associate<br><div>EnterpriseDB Certified PostgreSQL 9.3 \
Associate</div><div><br></div></div></div></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic