<div dir="ltr"><p class="" style="style">Hello,<p class="">The current process of transferring data files from one
clusterto another by using pg_dump and pg_restore is time consuming.<p class="">The proposed tool tries to make
migrationfaster for tables and indices only by copying their binary data files. This is like pg_upgrade but used for
migrationof table and indices<p class=""><p class=""><b><span style="font-size:10pt"> </span></b>The discussion here @
<a
href="http://www.postgresql.org/message-id/CAA-aLv5cQf09zvFRCB1XXUQLSp-ouX0S_Hq6ryScd6CtamipFQ@mail.gmail.com">http://www.postgresql.org/message-id/CAA-aLv5cQf09zvFRCB1XXUQLSp-ouX0S_Hq6ryScd6CtamipFQ@mail.gmail.com</a><p
class=""><pclass="">speaks of possibility detaching/attaching databases as an alternative to dump/restore. But the
processof freezing XID’s and zeroing out LSN’s make the solution equally time consuming if not more.<p class=""> But if
weconsider just tables and indexes to be detached/reattached, would this be a viable alternative to dump and restore of
tables?<pclass=""><p class=""> The same discussion indicates it could be done but is more complicated as one has to
dealwith system catalogs of the newly mounted table and map old OID’s to new ones. This is required to ensure
consistencyin roles, and objects owned by those roles.<p class=""><p class=""> We would also need to ensure LSN values
ofthe reattached pages are less than the current WAL endpoint in receiver.<p class=""><p class=""><span
style="font-size:10pt;font-family:Arial,sans-serif;color:black"> </span><span
style="color:black;font-family:Arial,sans-serif;font-size:10pt">Arethere any more issues we need to be aware
of?</span><pclass=""><span style="color:black;font-family:Arial,sans-serif;font-size:10pt">regards</span><p class=""
style="style"><spanstyle="font-size:10pt;font-family:Arial,sans-serif;color:black">Sameer</span></div>
