Re: Detach/attach table and index data files from one cluster to another

On 04/12/2013 10:15 AM, Tom Lane wrote:
> Sameer Thakur <samthakur74@gmail.com> writes:
>> The proposed tool tries to make migration faster for tables and indices
>> only by copying their binary data files.
> There's 0 chance of making that work, because the two databases wouldn't
> have the same notions of committed XIDs.


Yeah. Trying to think way outside the box, could we invent some sort of 
fixup mechanism that could be applied to adopted files? Of course, that 
could slow things down so much that it wouldn't be worth it, but it 
might be a nice research project.

cheers

andrew